Forum Discussion

Eureka's avatar
Eureka
Advocate I
5 years ago
Solved

Power Automate export 1000 rows only

Hello,   I'm usign the new Power Automate visual, to export my data to csv file and store in Sharepoint.   The probleme is  that this is exporting only the 1000 first rows. Do you know if  there ...
Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    Hi Eureka 

    It should not be affected by the configuration in Power BI. For an import mode report, the maximum number of rows that can be exported from the Service to a .CSV file is 30,000. It is very likely to be affected by the Power Automate. Have you ever tried to skip the creation of the intermediate CSV file and create the file directly in SharePoint? Or save the file to other file types such as worksheet?

    You can also post your problem in Power Automate Community to make sure whether there are some limitations on this feature. If you still have some question, please don't hesitate to let me known and please tell me some details of the Actions used in your screenshot.

     

     

    Best Regards

    Caiyun Zheng

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Issue is with data already comming from PowerBI to Flow. If you check the raw outputs of very first step of "On Power BI button clicked", JSON contains only 1000 data records.
I have same issue as well, however, there seems not to be any setting that can be triggered to increase row count neither on PowerBI, neither on PowerAutomate.