You’re offline. This is a read only version of the page.
Hello!
I am making automation to export the data we have on Power BI to a .csv. Here is my script:
The issue I am getting is that the csv only has 1,000 rows, and my data contains (currently) 1,516 rows.
I also tried to see if it was the "Apply to Each" function that was limiting it to 1,000, by simply making a csv from the raw data without formatting it. However, I still get only 1,000 rows.
Is there any workaround for it?
Thank you all for the help!
@microsoft , is this limitation going to be resolved? It cannot be due to data volume as there does not appear to be a limit on the number of columns that can be exported, so the 1000 row limitation would seem to be pointless. Also it is possible to create a Flow that queries the PBI dataset and produces a CSV of several hundred-thousand rows, so clearly it is possible for Power Automate to handle that volume of data (and Power BI should certainly be able to handle over 1000 rows!) so why is this limitation present when using the Power Automate visual inside a PBI report? This limitation makes no sense and it a significant impediment, especially as it makes no warning of this limitation when developing the Flow, instead it only becomes apparent when the dataset reaches that many rows which considering this is after the Flow has been developed is a massive irritation as it renders all the development work pointless and we have to start from scratch to find a new solution.
Comeon Microsoft, 1000 rows is not allot of data, and as Power BI is marketed as a world-leading business intelligence tool capale of handling many millions of rows, I am astonished that Microsoft find it acceptable to limit the export to such a tiny threshold. Seriously, what use case exactly is the Power Automate visual created for if it can't handle more than 1000 rows??!!
@mahoneypat would you be able to help me create a flow that gets the csv from the email?
Or provide me with additional resources to guide me perhaps
I tried same on my end, and 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.
FYI too that you can avoid the apply to each by doing a Select action with this expression
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (