How to publish a Power BI report and embed it in a website.

Power BI is a tool created by Microsoft to turn raw data into interactive insights.

The publishing process entails the below key steps;

• Creating a workspace
• Publishing power BI report
• Creating an embedded code
• Embedding the report on a Website

Here is a detailed process of the step by step process flow for a successful publishing.

1.Creating a workspace.
Open a browser and sign in with Microsoft account. Use below link,
https://app.powerbi.com

Select “Workspaces” on the left navigation pane, then click “New workspace”

Fill in the details populated, then click “apply”. This auto-populates your new workspace.

2. Publishing Power BI reports
Having created your own workspace, you can now upload your report using the below steps;

Open your finished report in Power BI desktop
Click “publish” on the Home tab;

Select a destination (the workspace you had created earlier), then click select;

The report is automatically uploaded in your workspace. Check your workspace to verify the uploaded data.

To open the report, click on it and it will automatically open.

3. Create an Embedded Code.
There are three different ways to embed a report;

Publish to web (Public)
Power BI gives you an iframe code you can drop into any website. It makes your report publicly accessible to anyone with the link. It is therefore not suitable for confidential reports. Here is how you go about it;

Open your published report in Power BI service, then under the report menu, click file >Embed report>Publish to web;

*Secure Embed (internal use). *

Viewers need to log in with their Microsoft account to see it. Great for internal company pages like a SharePoint site or Teams tab. It keeps the data protected without much technical setup.

Build it into your app (Developer route).

This one is for when you're building a product for a client for instance, and where they do not have Power BI Licenses. e.g., a SaaS tool. It requires more setup (you'll need to work with Azure and the Power BI API), but it's the most powerful and flexible option.

4.Embedding the report on a Website;

• Click File in the top menu
• Select Embed report → Publish to web (public)
• Click Create embed code
• Copy the iframe code that appears to your text editor (Vs code)
• Create a folder in your desktop and name it deploying/publishing.
• Open the folder in VS code and click select.

• under the folder, create a new file, i.e., index.html

Open this website in your browser https://www.w3schools.com/html/ and copy the html code and paste it in your text editor and save.

1. Go to the folder created in desktop (deploying/publishing) and select the folder, then click index;
2. Copy the url generated and copy it to your browser;
3. Go back to text editor (VC code) and delete “this is a paragraph)
4. History copy (windows + V) on the line you have deleted and it select iframe (the embedded code)
5. Copy the code above and go back to your browser and refresh.
6. You will get a sign in prompt, proceed to sign in;
7. After signing in, your report automatically load;

In conclusion, learning power BI has been an eye opening experience as a beginner data analyst. Going in, I expected it to be mostly about making charts look good, but I quickly realised that the real work happens long before you touch a single visual. Cleaning messy data and building a solid model is where most of your time and energy actually goes. Publishing felt like a milestone and is genuinely satisfying. Learning different ways of embedding reports as well felt more like a professional lesson, to ensure I do not publish publicly confidential information and face data breach suits.