Forum Discussion
Solved
SharePoint list query alternative or optimization
Hello everyone! Because sharepoint list queries quickly comes too slow to work with in Power BI, I have experimented with the query that sharepoint generates for excel. This is vastly more effect...
hjaf FYI that I finally made a video to describe this approach, and am adding it here for others that may find this post. It also gets the count of items and makes the right number of API calls.
Get SharePoint List Data with Power BI ... Fast - YouTube
Also, a reminder to mark one of these as the solution.
Regards,
Pat
mahoneypat you are a true hero! Thank you for the video and for the comment! Worked for me like a charm 😊
munchkin666 Please see this article I wrote on this topic.
Updated – Get SharePoint List Data … Fast – Hoosier BI
Pat