[Power Automate] Exporting a Power BI Report Page as an Image and Embedding it into a Word Document

Level of Difficulty: Beginner – Senior.

Now, we all know that data speaks volumes, but only if we can understand its language. Power BI has been a game changer in converting complex data into insightful, visually engaging reports. But there’s more magic in the mix! Have you ever tried extracting a Power BI report into an image and embedding it into a Word document? If not, let me explain why it’s worth considering. The process adds a whole new dimension to presenting and sharing data. You see, by transforming your BI reports into images, we can insert them seamlessly into Word docs. This makes the data easily digestible, ensuring we’re all on the same page. It’s about bringing data alive in a format that’s simple, portable, and best of all, doesn’t require Power BI expertise to comprehend. It’s like bridging the gap between data nerds and the rest of us, which is a win-win, right? So, let’s dive in and find out more about this.

To get Power BI content into a Word document, follow these steps:

1. Make sure that the Developer Tab has been added to the Word Toolbar
2. Add an image through the Developer Tab
3. Update the Properties
4. Create a Power Automate Flow with a defined trigger
5. Export the Power BI Report Page to an image
6. Populate the Word document with the image file content

Add Developer Tab

Navigate to File > Options > Customize Ribbon > Tick the Developer toolbox

Hit “OK” and navigate to the toolbox where you should see the following:

Add Image Placeholder

Focus the cursor on the part of the document where the image should be added. Select the Developer tab and select the Picture Content Control.

Once the image has been added, select and amend the Properties under the Controls section. Complete the Title and Tag properties:

Create Power Automate Flow

Navigate to Power Automate, then create a new instant flow (or add your required trigger). On a high-level, the flow should follow the following structure:

Export Power BI Report to Image (PNG)

Select the Power BI Workspace and Report along with the Export Format.

Power BI Reports are filtered using URL query parameters which are detailed in these Microsoft Docs. The structure of the query follows the following format:

<table name>/<column name> <operator> ‘<value>’

Populate the Word Document

Add the Populate a Microsoft Word Template action, then select the location (SharePoint, Teams or OneDrive), select the library and the file. The “Image Placeholder” will appear as the title you gave the image in the document when the picture content control was added. Assign the Power BI file content to the field.

Save and run!