Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 th...
Need Help
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

    • andrealibby5's avatar
      andrealibby5
      Frequent Visitor
      4 years ago

      Were you ever able to figure out a way to get past the 1000 row limit for the export?

       

      • MossyFresh's avatar
        MossyFresh
        New Member
        3 years ago

        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.