You’re offline. This is a read only version of the page.
4
Hello,
A client wants to export large lists automatically using power Automate in Power BI. Its quite simple, I have figured out how to do so, but instead of exporting the whole table in one go like some sort of bulk export, the Power Automate exports the table one row at a time, which is pretty slow, when a lot of rows needs to be exported.
Does anyone know if this flow or setup could be optimize or reconfigure to export the lists/tables quicker in bulk instead of one row at a time using "Add a row into a table"
I'll upload my current Power Automate Flow:
Hey v-xiaochen-msft,
Thanks for the response,
Nice - However, when I look through the link, I don't see how this can be applied in Power Automate. At least its not as clear and explicit as it should be. Have you used an API in Power Automate before?
Best Regards,
Br0007
Hi @br0007 ,
You could try to call a api to export your data to excel at once instead of using Apply to each.
https://docs.microsoft.com/en-us/graph/api/table-post-rows?view=graph-rest-1.0&tabs=http
https://www.tachytelic.net/2021/08/power-automate-export-to-excel/?amp#h-export-to-excel-done
Best Regards,
Wearsky
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
