Forum Discussion
Solved
Using query string from IQY file from Sharepoint "export to excel" as PowerQuery source in PowerBI
Hi, I'm trying to use a Sharepoint View as a source. I do this often with the Sharepoint List connector but there is one list I'm using is very large and complex and it can take a long time just ...
Please see this video on how to get data from a SharePoint list much faster.
Get SharePoint List Data with Power BI ... Fast - YouTube
Pat
mahoneypat Thanks, I'll check it out. Unfortuneatly the list is not SP Online but ratehr a SP2019 on Prem so there is no V2.. I'll try to get the REST solution working!!
Please see this video on how to get data from a SharePoint list much faster.
Get SharePoint List Data with Power BI ... Fast - YouTube
Pat
mahoneypat the REST API Function you provided is fabulous. Thanks!! I may also be able to repurpose it for a JSON query I was trying to use and was stuggling to handle the 5000 record limit!!