DEV Community

Mark Glemba
Mark Glemba

Posted on

HOW TO PUBLISH A POWER BI REPORT AND EMBED IT INTO A WEBSITE

INTRODUCTION
Power BI is an analytics tool developed by Microsoft that lets a user visualize and share insights on certain data. Power BI is also used transform and clean data using Power Query Editor. Data transformation occurs through; shaping data by filtering, sorting and grouping, adding columns and changing data types through conversion to; numeric, text etc. Data cleaning is done through; handling blanks, standardizing and removing errors.

PUBLISHING PROCESS IN POWER BI

  1. Create a workspace A workspace is like a folder where one stores reports, dashboards and datasets.

. Go to [https://app.powerbi.com/]
. Sign into your account
. Once your logged in, on the left far side click on workspaces


. Click on; + New workspace

2 .Uploading and publishing
. In the power bi desktop in the home page click on publish on the far right.


. Select your workspace where the report will be uploaded
. Once uploaded the dataset will appear on your workspace.

  1. Generating embedding code . Open the report you want embedded . Click on File ~~~~ Embed report . Choose embedding option; either Public (Publish to Web), OR Secure Embed; which requires log in and is more secure. . After clicking on Publish to web, Power BI will generate an embed link + iframe code.

4.Embedding code into website


. Copy entire code
. Open your website HTML file
. Paste the iframe code where you want your report to appear


. Save and open your website where your report will display.

CONCLUSION
Using Power BI with embedding capabilities promotes better collaboration, transparency and efficiency. This empowers users to embrace data-driven solutions that support smarter strategies and improved outcomes.

Top comments (0)