Forum Discussion
Increase row limit when creating CSV table
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
Hi Denis,
Yes. So basically I have dataset in Power BI and I am using Power Automate to compose and create a CSV table from those datasets. And then creating a CSV file in Sharepoint. But the export is always limited to 1000 rows.
Were you ever able to figure out a way to get past the 1000 row limit for the export?
The limiter is the Compose operation, to expand the row limit beyond 1000, you'll need instead to run a query against your dataset as your source when creating the CSV table.
Do you have an example of how to do this?
