DEV Community

Hadijja Musekwa
Hadijja Musekwa

Posted on

Publishing and Embedding Power BI Reports on the Web with IFrames

Introduction
Power BI is one of the most used tools for data visualization, reporting and analytics. It enables users to connect to different data sources, transform data and create interactive dashboards and reports.
However, many experience hardship in publishing created reports to the web and embedding it using iframe.
This article provides a detailed step by step guide on how to:

  • create a workspace in Power BI
  • Upload and publish your report
  • Generate an embed code
  • Embed the report into a website using iframe

Understanding Power BI Publishing
This is the process of uploading the repot from Power BI Desktop to Power BI service. the report can be shared and embedded into websites once published.

Creating a Workspace in Power BI Service
A workspace is collaborative containers used to create, manage and share collective reports and dashboards.

steps to create a Workspace

  • In the Power BI service (browser),
  • Sign into your account in the power BI service (browser)
  • Select Workspaces in the left pane, then New Workspace
  • select create > Workspaces > New Workspace

  • Enter Workspace name and description > save.

Preparing and Publishing the Report
Ensure the report is complete in Power BI Desktop before publishing.
Steps to Publish a Report

  • In Power BI Desktop, select Publish on the Home ribbon

  • Sign in to Power BI if prompted
  • select your workspace > select When publishing is complete, a link to the report will be seen. Select the link to open the report in your Power BI service.

Generating Embed code

  • open report in Power BI service

  • Click file > Embed report the click website or portal

  • Copy link to iFrame HTML

    Embedding report in desktop

  • Create a new folder in desktop

  • Open the new folder in text editor

  • Create a new file

  • Paste iFrame in the text editor

  • Save and copy on clipboard (Ctrl + A + X)

  • Copy a sample HTML from any website

  • Paste it in the text editor and save

  • Open folder in desktop

  • Open index in browser

  • copy URL

  • Delete paragraph 9 in text editor
  • Replace it with the iframe HTML and save

  • Refresh page and sign in if prompted

  • The Power BI reported will load

Top comments (0)