How to create effective public-facing reports in Microsoft Power BI

Featured in: /
Published on: 20 May 2024
Written by: Amruta Deshpande

Microsoft Power BI reports are often created and shared internally within an organisation to enable data-driven decision-making. In some cases, organisations may share their data insights externally via public-facing reports. Examples of this include informing the public of health or economic trends, or assisting the public in making healthy living choices. Such reports can be published using Power BI to a public-facing website, in an email sent out in a marketing campaign, or to a social media platform.

There are two ways to embed Power BI public-facing reports in a website:

  1. Website or portal: With this option, you can easily embed reports in a secure portal or intranet website.
  • Publish to web (Public): With the Power BI ‘Publish to web’ option, you can easily embed interactive Power BI content in blog posts, websites, emails, or on social media. You can also simply edit, update, refresh, or stop sharing your published visuals at any time. The ‘Publish to web’ option allows you to create an HTML iframe code or embed code which can be used in blog posts, websites, emails, or on social media with no authentication.

Considerations before posting public-facing reports to the website:

Care should be taken to understand the data that is being shared with the public to ensure no sensitive or personally identifiable information is being distributed. You must check internal company policies, regulatory guidelines, and legal implications before you allow access to any public-facing reports. Reports that need or rely on row-level or column-level security also cannot be published on the internet.

Steps to publish Power BI public-facing reports to the web:

  1. A Pro/Premium license is required to publish the report.
  2. If your Power BI admin hasn't allowed you to create embed codes, you may need to contact them.
  3. Open a report in a workspace that you can edit and select File > Embed report > Publish to web (public).
  1. After selecting the ‘Publish to web (public)’ option, you will get the below pop-up with some information. Click on ‘Create embed code’.
  1. After clicking on ‘Create embed code’, a warning will pop up. Ensure you have read and understood the warning before publishing the report.
  1. You can alter the size of the report as per your requirements
  1. After clicking on the ‘Publish’ option, you will get a link that you can share with the website admin to embed the HTML code/HTML iframe on the website.  
  1. The report may look like this on the website. You can add text or hyperlinks around the report as needed.

Note: you can manage any of your embed codes in Power BI Service using the ‘Manage embed codes’ option

You can also fetch the code or delete the embed codes using this option. If you want to stop sharing or publishing the report, you can delete the code.

The Ultimate Guide to Styling Your Power BI Dashboard

Interested in learning more about how to get the most out of Power BI? Not using a Style Guide means you are missing out on the full capacity that Power BI has to offer. Learn how to streamline your whole financial reporting process, expand user experiences and achieve complete branding consistency today with our free guide.

Related Articles

Copyright © Tridant Pty Ltd.

Privacy Policy
chevron-down