Forum Discussion
Power Automate Data Export
- 4 years ago
Hi Anonymous ,
Based on my test, this may be a limitation of Power BI Connector. And I create a flow to verify it.
Go to Power Automate | Microsoft Power Platform and create a new flow like below:
Then run it and find the history.
We can find that the input value of "Compose 2" is 1000, so we can be sure that the output value of the previous step "Compose" is restricted to 1000 rows. I haven't find any ways to remove the limition.
You can post your requirements on Power Automate Ideas - Power Platform Community (microsoft.com). And your feedback is highly voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , I saw this before 1000 row limitation .
There is an open ticket on Power Automate community
also, check
https://community.powerbi.com/t5/Desktop/Power-Automate-export-1000-rows-only/td-p/1811090