Forum Discussion
Power Automate export 1000 rows only
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!
Hello Caiyun,
Here is the flow I am using. Unfortunately it is extracting only 1000 rows.
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!
Hello, unfortunately my problem is still not solved.
the 1000 limit appears to be a limitation on the power automate visual. A workaround would be to just use the Export Data feature from a table visual with the same fields. Or, you can always make a paginated report from the same dataset, subscribe to it, and then use a flow to take the csv from that email, parse it, and do what you need with it.
During the Power Automate wizard I chose to create a CSV file in Sharepoint. It was also limited to 1000 rows. I don't see how this is solved?
Yes but it is not solving the problem
