Forum Discussion

learnagain's avatar
learnagain
New Member
3 years ago
Solved

Embedding Power BI visuals in Microsoft Publisher

hi

 

Some of our reports  are built in microsoft publisher wherein data/charts are pulled in from Microsoft excel

Wondering if we create visualsin power BI, can those be embedded to a microsoft publisher file ?

Would appereciate guidance on how to do that

 

Regards

Need Help
  • foodd's avatar
    foodd
    3 years ago

    Microsoft Publisher's original purpose was as a desktop publishing tool: Business Cards, Brochures, and menus. It is a (printed) page layout program.  It is not aimed at digital content and has no online equivalent in the Microsoft 365 landscape.    The ability to add HTML fragments was depreciated long ago, which limits the ability to embed HTML content.

     

    You can however use a different layout program that supports embedding iframes.

     

    Also, there is an option with Power BI to export a report to PowerPoint or as a PDF.   

     

     Here is a recent post: https://answers.microsoft.com/en-us/msoffice/forum/all/website-in-publisher/cbc64944-5c23-4871-91c3-3067dfba6f63

     

     

5 Replies

  • vaibhavkale570's avatar
    vaibhavkale570
    Resolver III
    3 years ago

    Hello,

    Yes, you can embed Power BI visuals into a Microsoft Publisher file. Power BI allows you to create interactive and dynamic visualizations, which can be easily shared with others. To embed Power BI visuals into Microsoft Publisher, follow these steps:

    1. Create the Power BI report:

      • Open Power BI Desktop or go to the Power BI service online.
      • Import your data and design the visuals you want to include in your report.

    2. Publish the report to the Power BI service:

      • If you created the report in Power BI Desktop, save the report and then publish it to the Power BI service.
      • If you created the report directly in the Power BI service, skip this step.

    3. Get the Power BI embed code:

      • Once your report is published to the Power BI service, open it there.
      • Click on the "File" menu and select "Embed report."
      • In the dialog box that appears, customize the report settings as needed (e.g., filter pane visibility, navigation pane visibility, etc.).

    4. Copy the embed code:

      • In the same dialog box, you'll see the embed code for your report. Click the "Copy" button to copy the code to your clipboard.

    5. Insert the embed code into Microsoft Publisher:

      • Open your Microsoft Publisher file where you want to insert the Power BI report.
      • Go to the "Insert" tab in Publisher.
      • Click on the "Online Video" option (Note: Although it says "Online Video," you can also use it for embedding other online content like Power BI visuals).

    6. Insert the Power BI report:

      • In the "From a Video Embed Code" window that appears, paste the Power BI embed code you copied earlier.
      • Click the "Insert" button.

    7. Preview and adjust as needed:

      • You should now see the Power BI report embedded within your Microsoft Publisher file.
      • You can resize and adjust the report as necessary to fit your layout.

    8. Save and share:

      • Save your Microsoft Publisher file with the embedded Power BI report.
      • You can now share this Publisher file with others, and they will be able to view the interactive Power BI visuals within it.

    Keep in mind that the Power BI report will be interactive within the Publisher file. Users can interact with the visuals, apply filters, and explore the data as they would in the Power BI service.

    • learnagain's avatar
      learnagain
      New Member
      3 years ago

      thank you so much.

      i will try this and revert back on result

      • foodd's avatar
        foodd
        Community Champion
        3 years ago

        Do you still need assistance in locating an alternative to MS Publisher for embedding Power BI reports?

  • foodd's avatar
    foodd
    Community Champion
    3 years ago

    Microsoft Publisher's original purpose was as a desktop publishing tool: Business Cards, Brochures, and menus. It is a (printed) page layout program.  It is not aimed at digital content and has no online equivalent in the Microsoft 365 landscape.    The ability to add HTML fragments was depreciated long ago, which limits the ability to embed HTML content.

     

    You can however use a different layout program that supports embedding iframes.

     

    Also, there is an option with Power BI to export a report to PowerPoint or as a PDF.   

     

     Here is a recent post: https://answers.microsoft.com/en-us/msoffice/forum/all/website-in-publisher/cbc64944-5c23-4871-91c3-3067dfba6f63

     

     

  • foodd's avatar
    foodd
    Community Champion
    2 years ago

    learnagain, checking in to see if you still need assistance with this issue, and if not, would you please mark a reply as a solution or follow up with a reply as a solution?    

     

    Please add kudos where assistance has been given / helpful.