AxioWorks Blogs
AxioWorks news, product updates, useful articles, hints and tips on how to make the most of your SharePoint data and Power BI Reports.
Using SSIS to Export Lists from SharePoint to SQL Server – An Alternative Approach
Find out how to export SharePoint List data to SQL server easily with SQList from AxioWorks.
Power BI using SharePoint List VS SQL Tables
Find out how to analyse data stored in SharePoint lists and libraries both online and on-premises in Power BI using SQList.
Comparison of BI Tools: Power BI vs Cognos vs Crystal Reports vs SSRS
Which is the best Business Intelligence (BI) tool available? Why is it the best and what distinguishable features makes it the best one? Find out more in our comparison blog.
7 Reasons why SQL Server tables are a better option for reporting than SharePoint Lists
Need to generate reports on data stored in SharePoint Lists? Find out how SQList helps overcome the limitations of SharePoint data querying.
Why use SQList to generate Power BI reports from SharePoint Lists, rather than using the Power BI native connector to SharePoint?
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…