Exporting tables from Power BI to Excel using Power Automate

Like (0) Share

Report

Posted on 8 Jun 2022 07:25:27 by br0007

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:

I have the same question (0)

All responses (3)

Answers (0)

br0007 4 on 10 Jun 2022 at 09:36:25

Like (0)

Report

Re: Exporting tables from Power BI to Excel using Power Automate

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

Was this reply helpful? Yes No
v-xiaochen-msft on 10 Jun 2022 at 03:58:38

Like (0)

Report

Re: Exporting tables from Power BI to Excel using Power Automate

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

Was this reply helpful? Yes No
br0007 4 on 08 Jun 2022 at 07:26:34

Like (0)

Report

Re: Exporting tables from Power BI to Excel using Power Automate

Was this reply helpful? Yes No