Forum Discussion
Apply Query Hangs
Hi all. I have a PBIX that connects to a SharePoint list. It refreshes every morning at 1am and takes roughly 15 minutes. I now need to expand an additional column - and I cannot get it to apply chan...
Please see this post for another way to get SharePoint List data that is very fast.
SharePoint list query alternative or optimization - Microsoft Power BI Community
Regards,
Pat
Thank you for the idea! I tried it but I'm guessing I'm doing something wrong:
#"Added Custom" = Table.AddColumn(#"Converted to Table", "SPItems", each Json.Document(Web.Contents("https://XXXX.sharepoint.com/sites/XXX/_api/web/lists(guid'{XXXX}')/items?$skipToken=Paged=TRUE%26p_ID="&Text.From([Column1])&"&$top=5000", [Headers=[Accept="application/json"]]))),
I'm sure it's something obvious but - it's not coming to me. My list is well over 5K. Oh, and the error it throws is "Expression.Error: Access to the resource is forbidden."