How to Make Power BI Report Public
You’ve spent hours cleaning data, designing visuals, and building the perfect Power BI report. Now, the final step is sharing it with the world. This article will show you exactly how to make your Power BI report public, walking you through the primary methods for sharing with an audience outside your organization.
First, A Critical Word of Warning on Public Reports
Before we go any further, it's essential to understand what "public" means in this context. When you use Power BI's "Publish to web" feature, your report and its underlying data become accessible to anyone on the internet. The report can be viewed, shared, and might even be indexed by search engines.
Never use this method for sensitive, proprietary, or confidential information. Think of it like publishing a blog post - once it’s out there, you should not expect it to remain private. Always double and triple-check that the data in your report is appropriate for public consumption before you begin.
Free PDF Guide
AI for Data Analysis Crash Course
Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.
Method 1: Using the "Publish to Web" Feature (The Easy Way)
The most direct way to share a report publicly is with the "Publish to web" feature. This generates a direct link and an HTML embed code that you can place on any public website, blog, or share directly with anyone, no Power BI license required for viewers.
What You’ll Need to Get Started
- A Power BI Pro or Premium Per User (PPU) license. Free accounts cannot use this feature.
- Administrative permission. Your organization’s Power BI administrator must enable the "publish to web" setting in the tenant.
Step 1: Ensure "Publish to Web" is Enabled in the Admin Portal
If you are not the Power BI admin, you will need to ask them to complete this step. This is a common hurdle, as the setting is disabled by default for security reasons.
- The admin needs to log into the Power BI service and go to Settings (the gear icon) > Admin portal.
- In the Admin portal, navigate to Tenant settings.
- Scroll down to the "Export and sharing settings" section and find the Publish to web option.
- Expand the setting and select Enabled. Here, you have a few choices:
- After selecting the appropriate option, click Apply. It may take up to 15 minutes for the change to take effect.
New reports created after this setting is changed will be publishable. Existing published reports will not need further changes.
Step 2: Generate the Public Link and Embed Code
Once the admin setting is enabled, you can publish your report from its workspace in the Power BI Service (not the Desktop application).
- Open the report you wish to make public in your Power BI workspace.
- Go to File in the top menu bar.
- Select Embed report > Publish to web (public).
- A confirmation dialog will appear, reminding you of the security implications. Be sure to read it carefully. If you are comfortable proceeding, click Create embed code.
- A final dialog box will pop up, asking you to confirm publication. Click Publish.
- Success! Another window will appear containing two options:
You can adjust basic options like the default page that loads and the dimensions of the embedded report right in this window before copying the code.
Step 3: Managing Your Public Reports
Over time, you might need to manage or remove the reports you've made public. Power BI gives you a central place to do this.
- Go to Settings (the gear icon) > Manage embed codes.
- Here, you will see a list of every report you have published to the web.
- For any report, you can retrieve the embed code again or click the ellipsis (…) menu and select Delete to permanently revoke access. Once deleted, the link and any embedded versions of the report will no longer work.
Method 2: Power BI Embedded (The Robust, Secure Way)
What if you need to share reports with external users but the data is too sensitive for the fully public "Publish to web" method? This is where Power BI Embedded comes in. It is a more advanced, developer-focused solution designed for embedding Power BI content securely within your own custom applications or web portals.
This method does not make your report "public" in the same sense. Instead, it allows users to view reports within your controlled application environment, often without them needing a Power BI license themselves because your application handles authentication.
Why Choose this Over "Publish to Web"?
- Security: The data is not publicly crawlable or viewable to anyone with a link. Access is managed through your application's security model. You can even implement Row-Level Security (RLS) to show different data to different users.
- Customization: You have full control over the user experience - what they can see, click, and export.
- Scale & Professionalism: This is the enterprise-grade solution for B2B portals, SaaS applications, and any scenario where you are providing "analytics-as-a-service" to your external customers.
What’s Required?
The setup for Power BI Embedded is more involved and typically requires a developer.
- Registering an application in Microsoft Azure.
- A Power BI Pro license for development within workspaces.
- A dedicated capacity plan, either Power BI Embedded (A SKUs) or Power BI Premium (P SKUs), to serve content to users without a Power BI license.
- Coding to integrate the embedded reports using the Power BI REST APIs and client SDKs.
While a deep dive is beyond a single article, it's important to know this option exists as the secure and scalable alternative to the "Publish to web" feature for any business-critical reporting needs.
Free PDF Guide
AI for Data Analysis Crash Course
Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.
Best Practices for Public Reporting
Whether you’re sharing a simple public visual or building an embedded analytics portal, following a few best practices will save you future headaches.
- Create Dedicated Workspaces: Don't publish reports from your team’s everyday "messy" workspace. Create a separate workspace specifically for reports intended for public sharing. This prevents accidental sharing of sensitive information and makes management easier.
- Simplify Your Data Model: Public-facing reports should load quickly. Before publishing, remove any unnecessary columns, tables, or complex calculations from your data model to optimize performance. A smaller data model means a faster, better experience for your viewers.
- Audit Regularly: Make it a quarterly reminder to check the "Manage embed codes" settings in Power BI. Ensure that only the reports you still want public are active and remove anything that is outdated or no longer needed.
- Never Publish PII: It bears repeating. Never publish any Personally Identifiable Information (PII) such as customer names, email addresses, phone numbers, or addresses using the "Publish to web" method.
Final Thoughts
Sharing your Power BI insights with a broader audience is a powerful way to demonstrate value and transparently communicate data. The "Publish to web" feature offers a quick and easy method for non-sensitive data, while Power BI Embedded provides a secure and highly scalable framework for sharing more complex reports inside your own applications.
Much of this complexity comes from the daily grind of logging into a dozen different platforms just to find the right data. We know how frustrating it is to manually download CSVs and struggle with complex reporting tools a good chunk of every week. At Graphed, we connect directly to your marketing and sales platforms (like Google Analytics, Shopify, Facebook Ads, and Salesforce) to build real-time, auto-updating dashboards. It automates away the setup headaches so you can just ask questions in plain English and get an interactive dashboard back in seconds - no admin settings required.
Related Articles
How to Sell Mockups on Etsy: A Complete Guide for Digital Sellers
Learn how to sell mockups on Etsy — from creating your first product to pricing, listing optimization, and driving consistent sales.
The Bookmarks Market: Trends, Opportunities, and How to Win on Etsy
The bookmarks market is growing. Discover the trends, buyer personas, and strategies helping Etsy sellers win in this profitable niche.
How to Start a Bookmark Business on Etsy: A Step-by-Step Guide
Thinking of starting a bookmark business? Learn how to design, price, and sell bookmarks on Etsy for steady creative income.