Forum Discussion

pthapa's avatar
pthapa
Post Patron
2 years ago

How to export data from PBI to SharePoint list using power automate flow?

Hello all,
I am having issues creating a flow to export data from PBI to SharePoint online list using power automate flow; need your help.

Scenario: 
I am trying to create a flow to "Run a query against a dataset" and send that export to SharePoint List; however when I tested the flow it throws one error saying the following message, not sure how to overcome with this issue.

 

 

 

Thanks in advance for your support.

pthapa

Need Help

4 Replies

  • christinepayton's avatar
    christinepayton
    Most Valuable Professional
    2 years ago

    Just want to throw out there that if you are trying to add 20,000 rows to a SharePoint list on a schedule you're going to have a bad time - your view threshold is 5k, and you'll start running into real issues when you have more than about 200k total rows in the list. SharePoint lists aren't really designed for bulk data storage. 

     

    Another technique you might try is to just run the dataset query in Power Automate and then pass the whole output to a JSON file, putting the run date in the filename to give it a unique filename (so it won't overwrite). That will create one new file each run, then you can connect to the folder in Power BI and expand the JSON files for a full history. You can pul the datestamp from the file creation date. When you expand the JSON, you'll get all the columns that the query returned. 

     

    This is all assuming you don't have a real database to use, it's better to do history tracking on that end--