Forum Discussion
Power BI : Sharepoint List Slow Refresh
Hi All, I have Sharepoint List as my source for which I am using direct connector provided by Power BI. Data is small in size but it is taking approax 2-3 hours to refresh which is absolutely not acc...
Anonymous Please see this post with instructions on how to get data from a SharePoint list much faster.
Regards,
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeAnonymous Please see this post with instructions on how to get data from a SharePoint list much faster.
Regards,
Pat
Pat, your video and code template are changing my life! Thank you for helping me out of the slow refresh rut I was in. I found a typo in your Query Version you may want to fix. In the third fieldselect line, $select=Id should have spaces before/after the =, like so: fieldselect = "&$top=5000&$select = Id...
Thanks again for sharing your knowledge! -Dan
