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

CmdrKeene's avatar
CmdrKeene
Helper IV
5 years ago

I'm loving this approach to use the paged response to get 5000-item chunks of list items quickly, but I'm wondering if anyone has gotten filters working with that in the same query? 

I realize I can retrieve all items and then filter in the query editor, but I'd love to get a pre-filtered output from sharepoint.

I tried adding $filter=Modified ge datetime'2021-05-08T09:59:32Z' to my URL string and at first I thought it was working, but then I realized my final results were showing a lot of duplication (the same items appearing many times). I think maybe the combination of filtering and pagination is causing the issue, but I'm not sure.