The main reason is that in practical terms using the native connector only works for small amount of data and simple queries. When you start using it on lists with many thousands of items and/or want to run queries across many large lists, you soon hit limitations in terms of amount of data you can query and the time it takes to execute them.
When you connect to a data source (e.g. a database, Excel file, or in this case SharePoint lists) from power BI you can choose two way of connecting to it:
AxioWorks SQList continuously export SharePoint lists and libraries as normalised SQL Server tables, making live SharePoint data available to reporting tools like Power BI, Crystal Reports, or SSRS.
The Power BI built-in connection to SharePoint only allows you to use the “Import” connection type.
Additional advantages of using SQList are:
Finally, there are some features that are available in Power BI when using “Import” rather than “Direct query” (this is good summary https://powerbidocs.com/2021/02/21/power-bi-import-vs-direct-query-mode-difference/), but that can be easily replaced by equivalent (and even more powerful) functions in the SQL Server side.
03 Dec 2021
Welcome to another exciting issue of our monthly Newsletter!
Each month, we try our best to bring to you content that is relevant and […]
30 Nov 2021
When we talk about the biggest annual tech conferences of the year, Microsoft Ignite comes to mind where not only we get a view of all their product […]
01 Nov 2021
25 Oct 2021
Power Platform provides a great way for citizen developers to develop Apps using low-code /no-code tools like PowerApps, PowerAutomate, and PowerBI. […]
18 Oct 2021
The main reason is that in practical terms using the native connector only works for small amount of data and simple queries. When you start using it […]
15 Sep 2021
Lists are primarily used as a source of data storage in the world of SharePoint and in most scenarios these lists can grow really fast especially if […]
30 Aug 2021
16 Aug 2021
In today’s world, data analytics has to become pivotal for making informed decisions and decision-makers are always keen to find new and innovative […]
01 Aug 2021
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.