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
Most Valuable ProfessionalHi 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