Power BI is a set of software services, applications, and interfaces that work together to transform disparate data sources into logical, visually immersive, and engaging insights. Your data might be in the form of an Excel spreadsheet or a combination of hybrid cloud-based and on-premises database systems.
Power BI makes it simple to connect to your sources of data, analyse and understand what's critical, and share reports with individuals you want. In this article, we'll explain to you how to publish Power BI reports.
What Does It Mean to Publish to Power BI Report Service?
Ideally, Power BI is comprised of multiple components that all operate collectively, including these three basics:
- Window desktop application, better known as the Power BI desktop App.
- An online Software as a Service (SaaS), referred to as Power BI service.
- Mobile applications for Power BI available for Windows, iOS, and Android devices.
To publish a report is to transfer the dataset and any associated report created in the Power BI Desktop App to the Power BI Service, or from the Service to a webpage or Teams. We do this to create Dashboards if required and collaborate with colleagues by sharing Reports, Dashboards and datasets through direct sharing, or contained in Apps.
What Are the Different Platforms to Publish Power BI Report?
Most Popular Places to Publish Power BI Report
- You may publish report to web, which will provide you with a URL that you can share with anybody. This should only be reserved for publicly available data and insights as the URL would be viewable to anyone who accessed it.
- You may also embed Power BI report on SharePoint or any other portal that supports embedding.
Other Places to Publish Report
- You may share the report from the workspace
- You may activate an email subscription, which allows the user to receive a snapshot of your report as well as a link to the report URL.
- Even if your users do not have a Power BI license, you can still share your reports with them by using the Power BI embedded. (Click here to know how to publish Power BI report to web without pro license.)
How To Publish Power BI Report to Web?
You can simply incorporate interactive Power BI content in blog posts, websites, emails, or social media with the Power BI Publish to web option. You may also simply modify, update, renew, or discontinue sharing your published visuals.
Generate Embed Codes Using Publish Report to Web
- Open a report in a workspace that you can update, and then choose File > Embed report > Publish to web (public).
- If your Power BI administrator has not permitted you to create embed codes, you may need to contact them.
- Check the dialog content and then click Create embed code.
- Examine the warning and verify that the data is suitable for publishing on a public website. If so, click Publish.
- You may get a preview of the report in the Success dialog. Choose the Size and Default page options.
- If you previously established an embed code for a report and choose Publish to web, the dialog in steps 2-4 will not appear. Instead, you're presented with the Embed code dialog.
Each report can only have one embed code.
Things To Take into Considerations When Using Publish to Web
Publish to web is accessible for reports that you may update in your personal and group workspaces. It is not accessible for reports that have been shared with you or for reports that rely on row-level security to safeguard data. Publish to web does not yet support or provide access to the following types of reports:
- Reports generated using any Live Connection data source, including on-premises Analysis Services Tabular, Multidimensional Analysis Services, and Azure Analysis Services.
- Reports that use a shared dataset that is stored in a workspace separate from the report.
- Datasets that are shared and certified.
- Reports shared to you directly or contained in an app.
- Q&A for Power BI visuals.
How To Refresh Data That Has Already Been Published?
When you share your Publish to web embed code, the report is updated with any modifications you make. The embed code link becomes active instantly. Anyone who clicks on the link will be able to see it. From the moment it is retrieved, the data is stored for one hour. As different visuals generally are created from different queries, perhaps to different data sources on different refresh schedules, it is best to stage updates to the data sources and therefore the published visuals during times when the embed code is less likely to be accessed, such as overnight.
Select "don't refresh" on the schedule for the dataset that the report uses to deactivate automatic refresh.
How To Check Your Published Report?
Once you've created a publish report to web embed code, you can check and manage it in Power BI's Settings menu. Managing embed codes include the ability to delete the destination visual or report for a code (making the embed code useless), as well as acquiring the embed code.