Power Automate Data Export

[Anonymous]

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

[Icey · Accepted solution]

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:

Then run it and find the history. 

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.

 

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]

@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