Unanswered

Rows decreasing when exporting file using Power Automate

(1) Share

Report

Posted on by MM-13052106-0

I am trying to export a file which contains 9200 rows using power automate. I have added all the required fields to a table visual in Power BI and ran the performance analyzer. The code I got was restricted to TOPN 501. I have removed the restriction and ran the query. It returned me all the records in power BI. I copied the same query and pasted it in power automate flow in "Run a query against dataset" step and tested the flow. The exported file contains only 3800 rows. Could it be a limitation in Power Automate?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

how many columns? Also always, always make sure to include nulls.

Was this reply helpful? Yes No
Ventit 422 on at

Like (0)

Report

What type of table? Excel, SharePoint etc.

Bothe those need to be modified in settings to the List Rows or the Get Items. Excel can only do 5000 rows and SharePoint can do 10000. Need to look at a loop process if there are more than the settings allow

Was this reply helpful? Yes No