How to Publish a Power BI Report and Embed it in a Website

#datascience #analytics #powerbi #dataengineering

Introduction

Power BI is a powerful tool introduced by Microsoft and widely used for its advanced data analysis capability. It allows users to transform raw data into interactive dashboards and reports that can then be used to derive insights and even aid in decision making.
Among its many functionalities, one could say one of the most important functionality is the ability to publish such reports and dashboards and even embed them to websites for easy sharing and collaboration.
In this article we look at the full process of publishing a power BI report from creating workspaces through to embedding the report in a website.

Step 1: Creating a workspace

Go to Power BI Service (https://app.powerbi.com/)
Follow the sign in steps and use your credentials to sign in to your account
This takes you to the Power Bi Service Home Page.
On the left panel click Workspaces

Click +New Workspace

In the pop up that appears enter:
- Name (Workspace name)
- Description (Workspace description - optional)

Click apply

Your workspace is now created and ready to be used

Step 2: Uploading and Publishing Your Report

Your report can be published from Power BI Desktop or you can upload it directly

Option 1:Publish from Power BI Desktop

Open your report in Power BI Desktop
If you are not already signed in, sign in by clicking on sign in in the top right corner and complete the sign in steps

In the top right of the ribbon, click on Publish

On the pop up, search your workspace name using the search bar

Click Select

Option 2: Direct upload on Power BI Service

On Power BI Service Home page, click on Workspaces on the left panel

Select your workspace or search for it in the search bar

Click on Import - Report, Paginated report or Workbook - from this computer

Browse and Select your file

Your report will now appear in the workspace.

Step 3: Generating the Embed Code

Navigate to your workspace page in Power BI Service and open your Power BI Report by clicking on the name
Click on File - Embed report - Publish to web(public)