This month Microsoft have released a new production ready version of Power BI Report Server as well as a updates to Power BI Desktop with new visuals and a variety of connectors moving to general availability.
Power BI Report Server Updates March 2018
This month Microsoft have released a new production ready version of Power BI Report Server that includes bookmarking, syncing slidcers and quick measures.
Bookmarking allows you to capture the currently configured view of a report page, […]
20 Mar 2018
When it comes to a reporting solution, Crystal Reports is the de facto standard in the reporting world.
In this blog we will cover how we can generate a Crystal report based on data from a SharePoint List. To do this we will first export the data from the SharePoint list to SQL Server using SQList. Once the data is exported in SQL Server, we will use Crystal Reports to create reports using the exported data. The data export process from SharePoint lists to SQL Server can be configured to be […]
18 Mar 2018
Tableau is one of the most renowned and accepted Business Intelligence tool for visually analysing the data by organisations all over the world. Tableau allows its users to create and distribute an interactive dashboard depicting the trends, variations, and density of the underlying data either in the form of graphs or charts. Tableau can connect to almost all types of data sources for fetching data. Data sources can be files, relational and Big Data; once the data is fetched it can be […]
23 Feb 2018
Nowadays, we deal with huge amount of raw data to make business decisions using Business Intelligence technology that helps in accelerating and improving decision-making, optimizing business processes, gaining new revenues and competitive advantage over business entrants. There are many BI tools are available in the market such as Tableau, Qlik, Power BI etc.
Microsoft Power BI is a cloud-based service that enables to collect, filter, combine, analyse and visualise and finally publish your data […]
12 Feb 2018
Microsoft Power BI provides a powerful way to visualise SharePoint data and build reports and dashboards on SharePoint lists and libraries. With the introduction of a Power BI web part (and the embed code) we can now also integrate these Power BI assets in our SharePoint sites.
In this blog post we will cover how to:
Create a Power BI report on a SharePoint list
Configure the Power BI report to use direct query on the SharePoint data to keep the report up to date
Embed the Power BI report in […]
13 Oct 2017
We are proud to announce a new release of SQList which provides even greater flexibility when exposing your SharePoint lists and libraries as a set of normalised SQL Server Tables.
Version 5.4 of SQList is a minor update from ver. 5.x.x, you can, therefore, upgrade for free if you have a licensed version 5.x. There are no breaking changes in this update.
There are some great new features in our SQList 5.4 release, namely:
Support for SQL Server Temporal Tables
SQL Server 2017 […]
12 Jul 2017
Highlights of the Microsoft SharePoint Summit 2017
Microsoft unveiled plans for SharePoint, Onedrive and Offiec365 during the SharePoint Virtual Summit today (May 16th)
Here’s a summary of some of the announcements and reaction to those
[View the story “Highlights of the SharePoint Summit” on Storify] […]
16 May 2017
How To: Import SharePoint libraries into Power BI and create links to the documents
If you have tried to import from SharePoint to power BI you have probably realised you can import Lists and folders but not libraries. In this post, which is based on a video by Ruth Pozuelo Martinez who is a microsoft MVP we’ll look at the Ruth’s suggested steps for doing the following:
Export the data from a SharePoint document library into the Power BI desktop
Create a visualisation that includes […]
02 Apr 2017
Page 14 of 17
Go to page:
Stay up-to-date with industry news and trends, SQL and SharePoint innovations and all the latest from AxioWorks by subscribing to our monthly newsletter.