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.
30 Nov 2023
Welcome to this month’s edition of the AxioWorks newsletter! We’re thrilled to bring you updates on our recent […]
16 Nov 2023
In the fast-paced world of technology, where new versions and updates are continuously rolled out, a recurring question often arises: “Why […]
30 Oct 2023
In the realm of synchronisation services, AxioWorks’ SQList and Microsoft’s Power Automate (earlier known as PowerApps) have emerged as […]
28 Oct 2023
As we step into the season of autumn, we are thrilled to share with you the latest developments and opportunities unfolding at […]
16 Oct 2023
In the ever-evolving world of technology and data management, the question often arises: “Why should I use a product like #SQList when I can […]
30 Sep 2023
September has been a bustling and exhilarating month for us at AxioWorks, filled with advancements, collaborations, and a whole lot of […]
19 Sep 2023
In recent days, I found myself immersed in an enlightening conversation with a friend, a fellow entrepreneur steering his ship in the vast sea of […]
28 Aug 2023
September seems to be a month of unexpected milestones and continued innovations at AxioWorks. As the summer wanes and the autumn […]
Power Automate, a part of Microsoft’s suite of tools, is increasingly becoming a preferred choice for automating workflows and business […]
16 Aug 2023
I spent the entire weekend writing code, not because of deadlines to meet or million-pound dreams, but for the kick that I still get from doing it. […]
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.