Forum Discussion
Advocate IICan i Export an Excel file from Power BI using Power Automate
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.
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
2 Replies
- Expiscornovus
Most Valuable Professional
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
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.
