Forum Discussion
Increase row limit when creating CSV table
Hi all, I am exporting my data through power automate and using create CSV table. However, it seems limited to 1000 rows. I have around 100K rows which I want to export. Is there a way to increase this? Thank you in advance.
10 Replies
Hey Anonymous ,
help me to understand your problem better.
You are exporting your data from a CSV with Power Automate? And in Power Automate the first 1000 rows are getting exported instead of 100K rows. Is that right?
Best regards
Denis
Were you ever able to figure out a way to get past the 1000 row limit for the export?
These guys have no limitations with exporting over 30K rows - https://go.christiansteven.com/knowledge/pbrs-for-power-bi/pbrs-technical-faqs/what-are-the-limitations-when-exporting-power-bi-to-excel-or-csv-using-pbrs
Hi Anonymous ,
The maximum number of rows that Power BI Desktop and Power BI service can export from an import mode report to a .csv file is 30,000.
You must have meet some limitation in power automate. I suggest you open a thread on power automate forum.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hey Jetryx, were you ever able to get around this? I'm having the same issue.
This seems to work for me. Pretty annoying and shouldnt be needed but that's the world we live in.
How to Run a Query against a Dataset Using Power Automate? - Enjoy SharePoint
