Power Automate to export a Power BI Cloud Report to excel and automatically publish it to website

[PBIFanHook7]

How to use Power Automate to export a Power BI Cloud Report to an excel file and then automatically publish the excel file to a website? We would like to automate the entire process. 

Thanks in advance for all responses, suggestions, and help. 

[v-achippa]

Hi @PBIFanHook7,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Ritaf1983 and @alish_b for the prompt response. 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[alish_b]

Hey @PBIFanHook7 ,

You won't be able to directly export Power BI reports (.pbix/.pbip) as Excel file (only PDF, PowerPoint (PPTX), and PNG formats). However, you can export data from the Power BI report to Excel by using the Run a query against a dataset action to execute a DAX query against the data model, then use the Create table or Add rows to a table action (Excel Online connector) to export the returned rows to Excel. Note this produces a plain data file with no formatting. Once you have the Excel file, depending on your website type, use the Create file action (OneDrive for Business/SharePoint connector), Upload file action (FTP connector), or HTTP action accordingly to publish it.

However, if you're working with Paginated Reports (.rdl files), Excel export is straightforward and natively supported. Use the Export to File for Paginated Reports action with Excel format selected. The subsequent steps for publishing to your website remain the same.

Hope it helps!

[Ritaf1983]

Hi @PBIFanHook7 
According to export power bi , please relate to the linked guide :
https://www.youtube.com/watch?v=BsXZUaarFWM

According to other try to ask in power automate forum:

https://community.powerplatform.com/forums/thread/?groupid=46ce02a3-e1a7-4176-81fc-d93a4001d287

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly