Forum Discussion
SharePoint list query alternative or optimization
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
The field in questrion is called Name, which appears to be a text field. This field is required as it links back to a SharePoint attachment so I wish to use the values contained to connect to the corresponding attachment via its URL.
The field in question IS exposed if I use a v2 connector, but I did not want to go down this route and would much rather use your solution.
That's really odd, for me all the text fields just show up. Is it maybe a lookup field on the front-end of SharePoint? Or you're sure it's either "single line of text" or "multiple lines of text" on the list itself?
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?
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?
Not sure, but I shall certainly go back to the developers.
Thanks for the info Cmdr, you need a promotion to CAPT.