Forum Discussion
Post PartisanExporting Power BI Table visual as CSV to SharePoint Folder using Power Automate only gets 500 rows
6 Replies
- christinepayton
Most Valuable Professional
Most of the "get" actions in Power Automate use pagination, meaning they return the first 500 rows by default, then stop. If you want them to return more, go in the settings for the step that gets the data and enable pagination, then set the threshold to above the maximum number of rows you expect to need to get.
POSPOSchristinepayton - Thank you for your response. I have not used Get actions in my flow and I do not fine a step which as "Pagination" in my flow. Can you please provide details of which step I should be changing from my flow below.
- christinepayton
How many columns are you querying? The limit on the "run a query against a dataset" is 1million values, with values = rows x columns. If you have a lot of columns, I would reduce the number. But also try running a length() expressionon the "run a query" output in a compose action to see how many rows the output has for that action specifically - that will tell you if you if the issue is that step or another step.
vicky_Super User
If you've just copied the code straight from the performance panel, remove the section at the end that starts with TOPN(501...) and update the evaluate part accordingly.
