Forum Discussion
Slowness in SharePoint to PowerBI data loading
Hello, I have basic knowledge of PowerBI and in my current use case, I am building a powerBI report. It has a live data connector to sharepoint lists which has 6000+ rows and 199 columns. I remov...
You can try using incremental refresh, or put the query into a dataflow and connect to that instead of directly to the list. That offloads some of the processing.
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview