Dynamically Embed a Web Page in a Power BI Report

[@taveda]

I followed your steps. However, in my Workspace, the websites are not reflecting with error as REFUSED TO CONNECT. While writing the HTML code, Power BI is generating as 'Table'[URL] with the logic writing. But in your formula, I can see the URL prefix is generated as Website[URL]. May I know, how did you achieved it?

[@cheema354jb]

same

[@janeqin6130]

I can't find html viewer in marketplace. when I searched it online, I got 404 error. Is it no longer available?

[@MarcelMilcent]

I found a good explanation to handle this at dataveld.com/2020/04/11/how-to-obtain-a-power-bi-custom-visual-if-it-no-longer-appears-on-appsource/ and the file for the html viewer at github.com/deldersveld/power-bi-sunset-visuals/blob/master/Custom-visuals/HTMLViewer.pbiviz

[@bisamurai]

Hi Jane. You can get the HTML Text Styler Visual from the AppSource

[@AntonioSantos-ve6zv]

Hi! Great stuff! Tried it here with a certain URL, but without any success. It renders when I try it on a text editor, saved as HTML and open on a browser, but it doesn't render on Power BI Service. Any hints?

[@marcovargas8086]

doesnt work with LinkedIN

[@rekhajv5334]

Thank you so much for sharing. I see that the hight and width are not changing for me

[@kedar09]

Hey Parker. I aim on integrating a web page on my PBI report which comprises of some data and that too it asks me my sign-in credentials before viewing the content. I followed your procedure and the login page is getting rendered without any problem. However, after entering my credentials and clicking on “login”, it doesn’t give me an expected response (data showing up). It just does nothing after clicking on login. What can be done to solve this problem? Please help. Thank you.

[@arieljaramillo9811]

Curious to find out if you found a remedy to this issue. I'm embedding a form and nothing happens when you submit

[@oraclebless]

Hello, I follow your steps and downloaded the sunset visuals in github , but however when I published it the url refused to connect.

[@matthewsalyer5216]

Same issue here!

[@cheche79e36]

great video! I was able to follow all the steps but webpage wouldn't load when I was done. is there any settings which need to be enabled for this to work?

[@BIElite]

+cHE cHE79 E open up the console by right clicking and selecting inspect. There may be an error method with some useful information. It's possible that the website you're trying to render doesn't support s orange you're behind a corporate proxy. Let me know if you can get a read on the error message

[@rohitnegi6376]

Have a question....how can we dynamically draw a target line in power bi for waterfall chart?

[@pablovallejoruiz3678]

I cant find the visual in the market :(

[@hotmasipayung4669]

thank you so much for you sharing.. but, i want to know, that is it possible to get from local URL?

[@MarcelMilcent]

Same doubt here. I have tried to point to a local html file, to no avail.

[@bennylbkooi]

Thanks for your video! I believe the visual is now called 'HTML Content', but I just based on the icon similarity 🙂 Unfortunately, I do face an issue of the webpage "refused to connect" ... what's up and how do I fix it? Hope to hear from you, thanks

[@mireyavera4029]

Thank you, I needed to implement this to one of my job tasks and I wasnt sure how to. You're amazing!!

[@scramiro1]

Nice! Is it possible to save filters clicked on the embedded webpage?

[@scramiro1]

No, it doesn't work using bookmarks

[@anukritisingh4931]

Hi, The video is very clear. However I have a doubt. I am unable to get import from marketplace option available in my power BI desktop. I am using the current Power BI Desktop version (May 2022) Can you please help me on this.

[@duncanwil]

Very fast paced but I got it to work successfully ... except for the slicer. My slicer looks like yours except that they do not show the title like such as SQLBI, they show the URL of the bog page I am linking to ... I am guessing it's a matter of ordering the slicer columns to get the title to the top ... your help is appreciated!

[@BIElite]

Hi Duncan, did you bring the URL or title column into your slicer? It sounds like you just need to make sure you brought the title into the slicer and then the titles will show up. Let me know if this helps!

[@duncanwil]

BI Elite I’ve got everything in my table that you have but the titles aren’t showing on the report. The links work but the slicer shows URLs only ... not so attractive!

[@duncanwil]

@@BIElite I could not fathom this but I thought it might be that I created my slicer with its columns in a different order to yours ... I created another file and this time I took more time and care over everything and I now have a page that looks and behaves like the one you demonstrated so problem solved. One other thing, given autocorrections being so powerful these days, I found a couple of my entries that were not right and once I corrected those, the whole thing worked better, no surprise. It now looks good so thanks for sharing this, Parker

[@DroneEyes]

Hi BI Elite, I loved your trick! Would be possible to download your PBIX file? I tried with many URLs and none of them worked (including the ones you used on your example). Thanks

[@holt59454]

hi there, how did you resolve this, i am having the same issue

[@DroneEyes]

​@@holt59454 No I have not

[@D33_83]

Hi, thanks for sharing the tip. Are you able to share you PIBX file.

[@dhcastrog]

I cant to show a pbi report when has RLS security?

[@ringovski1980]

What is the URL column, i created a new calculated column and entered a URL and PBI doesn't accept it.

[@sudhakarkatamneni2061]

Hello, I am new very new to Power BI. can you tell me how did you create those buttons/filters/slicers on top of ? I am referring to Excelerator BI, PowerPivot Pro, SQLBI buttons on top of iFrame.

[@BIElite]

Hi sudhakar, that's simply a slicer with 3 options! I created a separate table for these options.

[@mohammedALI3]

I want to ask if this feature available in power BI, I have a web site 'portal', I want to show power by Report inside portal using Link Or button , the report must be shown based on the user ID That is Login, such as if user id = 500 the report must show all data for user 500, if the get coming user id = 520 the report must be shown ll data for user 520.

[@BIElite]

Hi mohammed, this is possible with Row Level Security. Please check out the documentation here: docs.microsoft.com/en-us/power-bi/service-admin-rls

[@mohammedALI3]

@@BIEliteElite thanks for replay, Is (RLS) work using website user " portal user" and haven't power Bi Account?

[@matheusmoraes5945]

Hi, I'm brazilian and your video helped me a lot. Thanks!

[@unnishnk1393]

Thanks for the video.. wanna know how to access the URL with login id and password?

[@ST-fd6bi]

HTMLViewer visual cannot be found in market place anymore. Is there an alternative way? Or alternative visual?

[@rahulvartak5431]

Can we pass the values of filters selected... as Querystrings to the URL in the HTML View webpart ?

[@salmanshaikh8665]

please share video "how we upload video in dashbaoard"

[@shreyasvishnupurikar2195]

How do we know that the webpage is allowing other domains or not( which websites can be accessed ? )

[@BIElite]

Unfortunately you just have to try it out. Once you publish to Power BI Service, if it only shows a black screen you can inspect the page and see if you're getting an error.

[@GabrielRocha-po9fz]

I can't find the HTML Viewer add-on in the marketplace. Is it still there? Or they removed it?

[@arieljaramillo9811]

I believe it has a new name: HTML Content. Logo looks like a shield with an 'S'

[@shishiriyer8965]

Hi I am getting this error when I am trying to change the size and make it fit the entire container. Please help me out. 404 Not Found nginx/1.18.0 (Ubuntu)

[@hemantrathod6235]

Exactly what I wanted !! Thank you very much ... I have a table and by selecting a record I am trying to open the page for that record. Somehow shows the link selected but doesnt open the page. stays blank, when I try to look at data I can see the column value there .

[@holt59454]

hi there, did you manage to resolve this ? i am having the same issue

[@hemantrathod6235]

@@holt59454 Hi, sorry been looking for the workaround I had for this problem, but cant find the PBI file as it was long time ago, I work in research so I move on to different tools as soon as queries resolved, I will ping you if I find that project I worked on.

[@hemantrathod6235]

@@holt59454 roughly I remember is, I created additional column, with concat I combined static part of URL and variable, then set target as , but if I find my project will send you the details.

[@gustavoxerez7363]

Hello!! I have follow your steps and tried to embed a Power BI dashboard using another Power BI dashboard. However, the dashboard did not appear. If I embed a personal website, it works fine. Do you know how to solve this? Thanks!!

[@yoscbd]

Thanks for a great video!, wanted to know if anybody has encountered the issue i'm having with i-frame embedding of secure power bi: In our web page, after the power bi report i-frame window is open for about 45 min its login off showing the "sign in" button. When a user try to click sign in the i-framewindow is not responding unless we refresh the i-frameurl on our page to make it reload on our page , only then user can sign in again. Anybody knows how to deal with this issue?i didn't find anything in the power bi community center.... thanks!! :)

[@TheMrWARLORD]

amazing man, even after 5 years!

[@brianbehnke3634]

Was this visual removed from the AppSource? I can't find it in the store. I did use it previously but now cant find it.

[@BIElite]

You're right! I don't see it in AppSource either. Luckily you can download it from here: blog.pragmaticworks.com/power-bi-custom-visuals-html-viewer

[@brianbehnke3634]

@@BIElite Thank you much, this is perfect! I appreciate your quick response.

[@patrickbooth7948]

@@BIElite That pragmatic works source has been taken down as well. Is there a pbi viz file available for download anywhere?

[@pavel_stafeev]

Really useful. Thanks a lot!

[@8g8819]

Hi, this is great idea. Do you think that it would possibile to embed SharePoint into Power BI?

[@BIElite]

Hey giavo, I'm not actually sure. I think the link needs to be publically accessible. Let me know if you get it working!

[@MrRohanroxx1]

Were you able to do it by chance? If yes then how ?

[@holves]

Is it possible to render youtube as an Iframe on BI?

[@BIElite]

No unfortunately. A lot of big websites don't allow you to embed their website in an iFrame. KZbin is one of them :(

[@marknasello2950]

I too am having trouble finding HTML Viewer, it looks like its been disabled. Is there another visual that can be used?

[@MarcelMilcent]

I found a good explanation to handle this at dataveld.com/2020/04/11/how-to-obtain-a-power-bi-custom-visual-if-it-no-longer-appears-on-appsource/ and the file for the html viewer at github.com/deldersveld/power-bi-sunset-visuals/blob/master/Custom-visuals/HTMLViewer.pbiviz

[@didierterrien6933]

That's great! Can you click on the links inside the web page to go to an other page?

[@BIElite]

+Didier Terrien yes you can!

[@Sol-fg2go]

One question:-- If i will embed tableau dashboard in power bi , To view this embed web page(dashboard) in that case all Do we need Tableau license to all stakeholder ?????? Please answer

[@jenniferstonesifer361]

Yes, the viewer would need a tableau licenses

[@nikkimarsh9402]

I followed all of the steps and the page is loading on my powerbi app, how long should it take to load?

[@BIElite]

Hi Nikki, it's always worked quickly for me. Which page are you trying?

[@amolkirpan5305]

Hey Parker, I am working on embedding power bi report/visuals into react app and vice versa. I need to show visuals from both (power bi & react) on a single screen. Is there any way by which I can add a slicer to that screen that will work on both visuals (one from power bi & one from react)? If anybody can add something to it please reply.

[@123jamalq]

Some URL is not opening i.e. azure.microsoft.com/en-us/services/cognitive-services/text-analytics/ or translate.google.com/. Why it is not opening, can u guide me please.

[@BIElite]

Hey Jamal, I'm going to guess that Microsoft.com does not allow their website to be rendered in an Iframe. Unfortunately, I don't think there is any way to get around this. If you right click on your report and click on "inspect" and then go to the console, there should be some error messages that might help explain.

[@123jamalq]

Thanks for replying, this may be the reason but what so ever u shared it is outclass. Thanks for sharing such sort of stuff.

[@BIElite]

No problem. Glad your getting use out of it!

[@soy34mb]

Wow, excellent. I saw another video explaining this custom visual, I tried to replicate, but it was impossible. Your video was super clear. Thanks!

[@BIElite]

Nice! That's good to hear

[@Scallonesi]

Is there a way to embed pages such as Gmail where Password and ID are required?

[@BIElite]

+Scallonesi Yes you definitely can embed pages that require sign in. The embedded page will act exactly as if you are on the real page. I don't thing Gmail will work though. Google doesn't allow s to be used so I doubt Gmail would either

[@Scallonesi]

Thanks a ton for your quick reply! I had the chance in the meanwhile to test the method with several sites which require sign in and, unfortunately, I didn't have any luck so far... :(

[@BIElite]

After a bit of testing, I don't think you can use logins. I shouldn't have assumed. A login requires sending information across domains. I don't want to get to deep into the HTML unless you want to know, but I now don't think this will work. Sorry! But if you want to see the reason why it's not working, right click and inspect and you should see an error that says something like "Uncaught DOMException: Failed to read the 'cookie' property from 'Document': The document is sandboxed and lacks the 'allow-same-origin' flag." I think that's the issue.

[@Scallonesi]

I see, thanks for the explanation - very much appreciated!

[@zackziss]

How to access with oauth login

[@Amr-Ibrahim-AI]

Lovely! Thanks for sharing. I was looking for a way to show a PDF document inside the report. Will give this great tip a try in this context 👍

[@BIElite]

Nice! Glad you liked it. Hopefully this works for the same with a PDF

[@cantinmax1]

Were you able to display the PDF? I need to do the same thing using the download link for the document.

[@johnmatta9577]

@@BIElite Parker, have you tried it with images stored in Sharepoint or Onedrive?

[@girishsinghal8778]

@@BIElite You rock Parker. The tips you give are just fabulous. I was trying to display www.worldbank.org/content/dam/documents/sanctions/sanctions-board/2018/nov/SanctionsBoardDecisionNo-92.pdf into HTML viewer but it is not showing.

[@MrRohanroxx1]

@@johnmatta9577 Were you able to do it ?

[@rabsonlungu]

Parker, Very useful. Thanks for the KT

[@BIElite]

Thanks for watching Rabson!

[@sherifelgamal8686]

Excellent tip! thanks!

[@BIElite]

Thanks Sherif!

[@Broadmoore]

YES!!!!! HELL YES! Thank you!!

[@BIElite]

No problem! This is my favorite trick on the channel.

[@prashantkatiyar4173]

amazing .. was useful !

[@BIElite]

Nice! Thanks Prashant

[@mikeallen9529]

Awesome, great video

[@BIElite]

Thanks Mike! I also appreciate the tweet

[@jasmeengujral8686]

Amazing! You rock!

[@sadyaz64]

Thanks !!!!!!

[@BIElite]

Thanks for watching!

[@umarhussain4519]

If you know how to create html pages, this is extremely powerful! thanks

[@BIElite]

Right! I love this trick!

[@waltherleonardo8652]

Thanks!

[@BIElite]

Thanks for watching, Walther!

[@diegolozano2397]

SUPER TIP COLEGA

[@santoshraghunath8133]

Awesome

[@BIElite]

Thanks Santosh!

[@hotmasipayung4669]

brother, i search on market place but the visual HTML Viewer is no there.. can you help me?