cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jetryx
Frequent Visitor

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.

4 REPLIES 4
v-deddai1-msft
Community Support
Community Support

Hi @Jetryx ,

 

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

RBnNC
Helper I
Helper I

selimovd
Community Champion
Community Champion

Hey @Jetryx ,

 

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

Jetryx
Frequent Visitor

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.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!