Power Platform Community Forum Thread Details

I would like to know if it's possible to export a Power BI report as PNG and then insert each PNG image into a separate worksheet within an Excel workbook stored in a SharePoint library, using Power Automate.

Is this achievable with the available tools and connectors in Power Automate? If so, could you please guide me on the best approach to implement it?

Categories:

Building flows

You want to export a Power BI report as PNG images and insert each image into a new worksheet in an Excel file stored in SharePoint using Power Automate. Yes, this is possible using Power BI export action and Excel Office Scripts in Power Automate.

1. use trigger "Manually trigger a flow" or "Recurrence"
2. add "Export to File for Power BI Reports" action
   a. choose workspace and report
   b. format = PNG
   c. in "Pages" enter one page at a time (use loop to export multiple pages)
3. add "Apply to each" loop if exporting multiple pages
   a. inside loop, export each page as PNG
   b. get base64 of PNG file from export output
4. create Office Script in Excel Online (go to Automate tab > New Script), paste this code:
   function main(workbook: ExcelScript.Workbook, base64Image: string, sheetName: string) {
   let sheet = workbook.addWorksheet(sheetName);
   const image = sheet.addImage(base64Image);
   image.setPosition(0, 0);
   }
5.in Power Automate, add "Run script" action
   a. location = SharePoint site
   b. file = your Excel file
   c. script = the one you created above
   d. pass parameters:
   base64Image = output of PNG export
   sheetName = use dynamic name like "Page 1", "Page 2" etc
6. repeat step 5 inside the loop for each PNG
7. flow will add one image per worksheet in the Excel file stored in SharePoint

*Premium license is required for Power BI export and Excel script actions.