Introduction
Imagine (or if you can't imagine you can try this practically ) you have finished your analysis in powerBi Desktop and you want to share your insights, How do you share these well thought insights? Worry no more you're just at the right place at the right time to get better in PowerBi. Sit tight and Buckle up!
Well that's where publishing and embedding comes in - These are just 'fancy' terms trust me, these processes are as easy as ABC. The last step of preparing powerBi dashboard and reports is publishing or embedding so that you can share your reports to the concerned persons.
Before we continue learning, Let's get a clear difference between these terms. That is PowerBi Desktop vs powerBi service, publishing vs embedding.
PowerBI Desktop vs PowerBI Service
- PowerBI Desktop is a free Windows application used for building data models and designing reports. Power BI Service is a cloud-based web platform used to publish, share, and collaborate on those reports.
Publishing vs Embedding
- Publishing is the initial step where you upload a report from Power BI Desktop to the cloud (Power BI Service). Embedding is the secondary step of taking that published report and displaying it directly inside an external website, portal, or custom application (via an iFrame or REST API)
Pre -requisites
- Curiosity
- Accounts created in PowerBi service in your favourite browser(Premium account)
- PowerBi Desktop App
- VsCode or any other editor
- PowerBi report you want to publish/embedd
1. Publishing Reports
Publishing from Power BI Desktop is required when you want to move your local .pbix file to the cloud for sharing and collaboration. You should publish when your report is ready, requires team collaboration, or needs to be embedded into secured platforms like Microsoft Teams or SharePoint
- Below is a sample report I want to publish named ' diaspora remittance '.
- Create an account in PowerBi service as earlier stated by going to your search browser and searching for powerBi service.
- Using the same details also log in to your powerBi desktop service
- Create a workspace in powerBi service to hold your project eg I created one named ' Data_Remittance '
In your powerBi desktop click on publish on the top right and select the workspace you created in powerBi service
My work space was as below - The workspace I created in powerBi service. You should also be able to see yours here
After selecting your workspace. When you go back to powerBi service, you should see your powerBi reports under your workspace.
You can share the report as link to the targeted audience or person. This is one process.
2. Embedding Reports
Power BI embedding is used to integrate interactive data visuals directly into your web applications, internal portals (like SharePoint), or SaaS products. This allows end-users to analyze data without leaving their familiar workflows or logging into the external Power BI service
To get the code to use to embed the report; navigate to the file section within the published report in the powerBi service, select embed report then publish to web
Copy the HTML code. This you can use in your desired website by putting it within the codes of your website.
Below is an example how I embedded it within this sample web using VSCode editor.
This is how it looked within the sample web. Amazing!
Conclusion
Just like that, you can share your powerBi reports. Publishing and embedding reports in Power BI democratizes your data by transitioning static files into dynamic, cloud-based experiences. It bridges the gap between raw analysis and actionable business insights, allowing stakeholders to easily access, filter, and consume live data directly within their daily workflows.
Top comments (1)
wonderful article .