Forum Discussion

Seward12533's avatar
Seward12533
Solution Sage
5 years ago
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 ...
Need Help
  • Seward12533's avatar
    Seward12533
    Solution Sage
    5 years ago

    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!!

  • Seward12533's avatar
    Seward12533
    Solution Sage
    5 years ago

    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!!