Watch our presentation, where we are going to show you the best way to access live SharePoint data from any reporting and BI tool, like Power BI, SSRS, or Crystal Reports.
First of all, why would we want to report on SharePoint data?
Well, a lot of corporate data are stored in SharePoint companies’ sites and subsites. SharePoint, is no longer used to create just department portals or shared document libraries, but also to store actual business data, like customer details, shipping information, sales data, and so on.
And to have a full picture of your business, you must be able to perform BI and data analytics on the entirety of these data.
Unfortunately, accessing data stored in SharePoint is not easy and has many limitations.
Now, what if your SharePoint data were stored in neat SQL tables, and you could query it using SQL, and you could build your Power BI or SSRS reports from SQL tables and views, rather than connecting directly to SharePoint?
This is where SQList comes to the rescue!
Watch the video and see how quickly and easily we can create a Power BI chart from live data stored in SharePoint lists, thanks to SQList, our tool that synchronises SharePoint lists to SQL Server tables.
And make sure you do not miss the part where we explain how you can improve the performance of your BI reports and have granular access control, by adding a layer of views on top of your SharePoint data.
Enjoy!