Forum Discussion
How to Export More than 1000 Rows From a Power BI Report Using Power Automate Add Row To Excel Table
Hello
I've succesfully got a Power Automate Flow writing rows from a Power BI page to an Excel table via the Add Row To Table action but it will only export 1000 rows. I cant see where to change any settings to increase within the flow.
Any help greatly appreciated
Thanks
Anthony Key
4 Replies
Hi AnthonyKey
As far as my know, there is 1000 row limitation in Power Automate visual in Power BI Desktop. So if you want to export to csv file by Power Automate button, you need to consider this limitation.
You can put your ideas on the platforms below .
https://powerusers.microsoft.com/t5/Give-Feedback-Share-Ideas/ct-p/FL_Comm_Ideas
https://ideas.powerbi.com/ideas/
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
These resources may really help...
Send up to 100,000 rows from PBI to CSV: https://youtu.be/BsXZUaarFWM
Quickly convert a CSV to a new Excel table: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-To-Excel-Table/m-p/1826096#M964Does this work for a dynamically filtered visual though?
