Forum Discussion
Advocate IICan i Export an Excel file from Power BI using Power Automate
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.