Skip to content
5MinuteBI Creating Data Power Users 5 Minutes at a time

5MinuteBI

Creating Data Power Users, 5 Minutes at a Time

  • Home
  • Blog
  • About
  • Contact

How to Publish Power BI Reports to a Public Web Site

BySteve Young Updated onJune 25, 2023

An often overlooked, yet powerful feature of Power BI allows you to publish a report to a website using an embed code. This puts the report and underlying data out for everyone who has access to that web page. The sample page below shows a sample book I published for a training session. The following how-to will walk you through will the steps leverage this feature on your site.

This will publish and make available all the reports that are contained in the Power BI workbook.  As shown below, it may look a little small in this template, however, click on the full-screen button on the bottom right of the iframe for a larger view.

  1. Create an Application Workspace to house your Power BI Reports. In your Power BI service, select Workspaces, then Create app Workspace. Being a shared report, I usually put these in an application workspace as a rule, however, is not a requirement.  Better to seperate your projects by workspace rather than having everything in one spot.
    Create Application workspace

    2. Fill in the details. These details are really for the workspace and how you organize your development and QA teams.

Fill in application workspace details

3. From your Power BI Desktop workbook, select Publish. If you have multiple subscriptions make sure which one your accounts Power BI desktop is logged in as.

4. Select the workspace you have just created to house the published content.

5. You will get a successful message when complete.

Success Publish Power BI Report for Public Website

6. Now that we have the published report, select File, and Publish to Web from the report you wish to publish. This will bring up the embed code.

7. This will bring up 2 dialog boxes that describe the service. Remember that all users that have access to that page will have access to the reports and the data that is published in the Power BI workbook.  Review the screen captures here as they explain how this share will work.  This report will be live and will continue to receive updates that you have scheduled on the data source.

Remember that everyone on the Internet, or the security you have your on the web page (Membership), will have access to see the data in the reports and the data set, just as a normal user.

8. The Success dialog will have the two links you need. One to link that you can provide an email notification to any users, and the other is the iframe embed code.  You can change the size based on what you need, however, the final displayed result will have a “Show in Full Screen” icon.

 

9. The following code can be tested in a local HTML page by using your embed code. Save the file to your local system and open in the browser of your choice to test.

 

<!DOCTYPE html>

<html>
  <body>
    <h1>My First Heading</h1>
    <p>My first paragraph.</p>
    <iframe width="800" height="600" src="https://app.powerbi.com/view?r=eyJrIjoiNzc ..... jN9" frameborder="0" allowFullScreen="true"></iframe>
  </body>
</html>

 

Being able to share a report, samples, or public data on your public website is an amazing feature that you get with the Power BI service.  Share back if you use the same feature on your site, I would love to check it out!!   DM me on Twitter.

Reference

https://docs.microsoft.com/en-us/power-bi/service-publish-to-web

Related

Steve Young

With over 34 years of experience in the data and technology industry, the last 16 with Microsoft, I have had the opportunity to work in various capacities, contributing to my knowledge and expertise in Data Engineering, Power BI, and Data Visualization.

Facebook Twitter Instagram YouTube Linkedin Pinterest

Meta

  • Log in
  • Entries feed
  • Comments feed
  • Powered by WordPress.com.

Disclaimer: The views expressed are my own. I offer no guarantees for the accuracy of the information shared, and it is for educational purposes only.

All non-original photography is sourced and licensed from my account on PEXELS,  STORYBLOCKS, iStockPhoto, and Pixabay. Please use our Contact Page if you have a question.

The information provided on this blog is for educational purposes only. Steve Young is not responsible for any errors or omissions or for any actions taken based on the information provided on this blog.

© 2023 5MinuteBI

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT
  • Home
  • Blog
  • About
  • Contact