How to Export More than 1000 Rows From a Power BI Report Using Power Automate Add Row To Excel Table

[AnthonyKey]

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

[takolota]

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#M964

[Ry009]

Does this work for a dynamically filtered visual though?

[Anonymous]

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.

[MFelix]

Hi @AnthonyKey ,

Check if this post helps

https://powerusers.microsoft.com/t5/Building-Flows/Power-BI-gt-Export-to-Excel-gt-email-Excel-to-use...