Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Power Automate Data Export

Hi everyone. First post here after trawling for a few days looking for an answer - hoping someone knows a solution to my issue.

 

I've imported the 'Power Automate for Power BI' (flow) visualisation into my report, and linked a flow to provide me an 'Export Data' button - allowing for control over what users export data, and what data they can get. The exported data gets dropped to a CSV file and pushed out to a sharepoint folder they have access to with the relevant datestamp. 

 

The process works perfectly. However, it truncates at 1000 rows.

 

I've read that BI -> CSV has a 30k row limit. No problems there, the data I'm playing with is a smidge over 9k and should usually be on or around that, so a 30k limit is bags. Outside of this 30k limit, I cant find anything on other limiting factors that would cause the 1k truncation I'm getting.

 

I've done all the usual - check the flow, delete everything, start again.. If i drop the data into a table in the BI report its 100% all there.. 9k rows and has been validated so, data's good. 

 

The flow basically goes:

On Power BI button clicked -> Compose -> Create CSV table -> Create File (sharepoint)

 

Has anyone come across this limitiation with CSV file creation from data before? Is this truncation expected behaviour? Is there a way around it?

 

Thanks

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Syndicated - Outbound

Hi @Anonymous ,

 

Based on my test, this may be a limitation of Power BI Connector. And I create a flow to verify it.

 

Go to Power Automate | Microsoft Power Platform and create a new flow like below:

 

length flow.PNG

 

Then run it and find the history. 

run history.pngrun history 2.PNGrun history 3.PNG

 

We can find that the input value of "Compose 2" is 1000, so we can be sure that the output value of the previous step "Compose" is restricted to 1000 rows. I haven't find any ways to remove the limition.

 

You can post your requirements on Power Automate Ideas - Power Platform Community (microsoft.com). And your feedback is highly voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 history.PNG

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Icey
Community Support
Community Support

Syndicated - Outbound

Hi @Anonymous ,

 

Based on my test, this may be a limitation of Power BI Connector. And I create a flow to verify it.

 

Go to Power Automate | Microsoft Power Platform and create a new flow like below:

 

length flow.PNG

 

Then run it and find the history. 

run history.pngrun history 2.PNGrun history 3.PNG

 

We can find that the input value of "Compose 2" is 1000, so we can be sure that the output value of the previous step "Compose" is restricted to 1000 rows. I haven't find any ways to remove the limition.

 

You can post your requirements on Power Automate Ideas - Power Platform Community (microsoft.com). And your feedback is highly voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 history.PNG

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

Syndicated - Outbound

@Anonymous , I saw this before 1000 row limitation .

There is an open ticket on Power Automate community

https://powerusers.microsoft.com/t5/General-Power-Automate/exporting-more-than-1000-rows-from-Power-BI-to-excel-or-CSV/td-p/1227059

 

also, check

https://community.powerbi.com/t5/Desktop/Power-Automate-export-1000-rows-only/td-p/1811090

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)