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

ElliotK's avatar
ElliotK
Helper I
4 years ago

Hello CmdrKeene,

 

I hope you are well?

 

Thank you for looking into this. I have spoken to the developer and have been advised that the name is indeed a lookup. Apparently it does not appear on the underlying dataset, which I understand. It's a shame as the v2, whilst extremely slow, does pick up the field. Maybe because it is interogating the UL rather than the data itself?

 

Is there a way to GetByForm or GetByURL?

CmdrKeene's avatar
CmdrKeene
Helper IV
4 years ago

I can't think of a great workaround for lookup field really. Is it possible to retreive the data and then use a merge or relationship to perform the lookup in the query?

  • ElliotK's avatar
    ElliotK
    Helper I
    4 years ago

    Not sure, but I shall certainly go back to the developers. 

     

    Thanks for the info Cmdr, you need a promotion to CAPT.