How To Embed Websites Into Power BI
Have you ever been curious whether it is possible to embed a website into Power BI dashboard? Well, there are ways to embed a Power BI dashboard into a website which has a different method and purpose, I would be covering it in future.
In this post I would be covering the other way round i.e. embedding a website into Power BI dashboard which is less talked about.
There are various ways in which this can be used, however I am trying to explain this using simplest example possible.
Objective:
To create Power BI visual that renders a website and lets user dynamically switch between websites using slicer.
Step 1: Import Custom Visual
To begin with you would need a custom visual called “HTML Content” from Power BI app source.
From the visualizations pane > Get More Visuals
Search “HTML Content” and add it to your visualization pane.
Step 2: Create website details table
Create a table using “Enter Data” and insert the website names and their URLs
Step 3: Add column with HTML String
Add a calculated column named “iFrame” in same table as shown below. This concatenates the URL and with the required HTML string.
iFrame = “<iframe src=” &”””” & Websites[URL] & “””” & “width=””100%”” height =””560"”></iframe>” & “”””
Step 4: Add Website Slicer
Add a slicer with field containing website names i.e. ‘Website’ in this case.
Step 5: Add the newly imported visual into the canvas and drop “iFrame” field into it.
Nothing went wrong here it just that websites aren’t visible in the Power BI Desktop file. :(
Step 6: To view the websites, host the Power BI desktop file on Power BI report server / service.
Once hosted on reporting environment you should be able to get something like below.
BAMM! Now you can select any website in the slicer on left and accordingly in right visual the website would be rendered through which you can scroll and use it like a normal website.
Hope this helped you in some ways.
Like, Follow and Share for more such content.
Cheers!
