Can i Export an Excel file from Power BI using Power Automate

[MVenables]

Hi all,

I was wondering if you can use power Automate to export a table in PBI into Excel then have that emailed to people automatically. Rather than just having PDF, or Power Point files sent as effectively screenshots.

Any help on this will be fantastic, thank you.

[Anonymous]

Hi @MVenables ,

Have you already solved the problem? If so, can you share your solution here and mark the correct answer as standard to help other members find it faster? Thank you very much for your co-operation!

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[Expiscornovus · Accepted solution]

Hi @MVenables,

You could use the Run a query against a dataset action of the Power BI connector in a Power Automate flow. Laura GB has a nice blog about this (she has embedded it into an HTML table, but you could a similar approach with a create file action as well):

https://hatfullofdata.blog/power-automate-get-data-from-a-power-bi-dataset/

Alternatively, if it is a paginated report you could also use the Export to File for paginated reports (which supports csv and xlsx as export formats):

https://learn.microsoft.com/en-us/connectors/powerbi/#export-to-file-for-paginated-reports