Unanswered

Export to Excel from Power BI Work space using Power Automate

(0) Share

Report

Posted on by Brijith

Hi ,
i want to export the Contents of a power BI Table from the data model into an excel file and save to SharePoint. The table has 25000 rows and 21 columns ,
Currently i am exporting Manually from the Power Bi service. and full data is exported to excel . I would like to automate this process that happens every day . i tried creating a scheduled export using power Automate using query evaluate 'Table'. But this is exporting only 14000 rows .

Categories:

Building flows

Powerbi.PNG

I have the same question (0)

All responses (4)

Answers (1)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

There is no limit on the Power BI side (ish) but there is a message size limit in Power Automate. Are any of these columns large text columns?

Limits of automated, scheduled, and instant flows - Power Automate | Microsoft Learn

Was this reply helpful? Yes No
Brijith 11 on at

Like (0)

Report

Thanks lbendlin for your reply.
I have 21 columns. I removed 2 columns . now I have 19 columns . I tried another export from the flow and got 16k in the csv file (2k more than the previous export ). All columns are not having more than 10-15 characters.
but what is strange is that when I manually export to excel from Power BI service . All 20k records are exported. is there any other way to export a Power BI table . there is no summering or filter. All I need is an automatic export to SharePoint from a Power BI table

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

There was a bug a while ago that limited exports to 300000 items (rows times columns). Sounds like that bug is back?

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi

Was this reply helpful? Yes No
Verified answer

Brijith 11 on at

Like (0)

Report

Thanks lbendlin.
You were right. Data was truncated because of the threshold. Maximum of 100,000 rows or 1,000,000 values per query (whichever is hit first).
I used the loop logic to append the csv table as demonstrated in the video and got all my 20k rows
https://youtu.be/fbeMw9jtJB4?si=kQBOJ1huPMuWR6mG
https://curbal.com/curbal-learning-portal/export-more-than-100k-rows-of-power-bi-data-to-csv-using-power-automate

Was this reply helpful? Yes No