Forum Discussion

hjaf's avatar
hjaf
Advocate I
6 years ago
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...
Need Help
Tips and Tricks
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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's avatar
mahoneypat
Microsoft Employee
5 years ago

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

jaleman's avatar
jaleman
Frequent Visitor
5 years ago

Thank you, your video helped me. After I moved to version 2 everything was faster.

  • CmdrKeene's avatar
    CmdrKeene
    Helper IV
    5 years ago

    If you think version 2 is fast, wait until you try the "good" method using the REST API.  I have a list with more than 150,000 items, and it refreshes in about 8 seconds.