In this module you will learn how to use the HTML Viewer. The HTML Viewer allows you to display the results of HTML code within your Power BI reports.
Module 72 – HTML Viewer
- Power BI Custom Visual – HTML Viewer
- Dataset – Blog HTML.xlsx
- Completed Example – Module 72 – HTML Viewer.pbix
- Allows you to display HTML in its original style and formatting.
- Minor formatting can be applied to the overall output.
This HTML Viewer shows the HTML from my blog rendered on a Power BI report.
- Under the Format paintbrush there are only a few configurations that can be adjusted on this visual.
- Under the Content Formatting section you can determine if you want to display the formatting from the HTML code and you could use Power BI to apply formatting the the results instead.
You can also adjust the background color, add a border around the visual and lock the aspect ratio under the Format section.
Find Out More
You will always be able to find this video module and advanced viewing of future modules on the Pragmatic Works On Demand Training platform. Click here to learn more about this training platform that includes 30+ courses.
Catch up on all the Power BI Custom Visuals blog posts here.
Here is the dumb question – in the Excel sheet example, you have a HTML column. I only see text (and only a bit of text) in that column. So, the dumb question is – what did you copy/paste into Excel (how?) to get it to appear in the visual like on the web page?
Hi Collin, There’s actually a lot of text in those columns if you expand it you’ll see there’s an entire blog post in that cell.
OK, thanks! I see that now. And, how did you copy the text from the website so that only the HTML tags came through?
Ah this just came from my blog editor. WordPress let’s you view the HTML of anything you post.
Hi Delvin. Is it possible to get hyperlinks to work properly? For example, if I include something like Goto Google it is properly formated in the visualisation but when you click on it, nothing happens. If I hold down CTRL it works although this is not ideal. Thanks, Nick
I believe the ctrl click only occurs when you’re in the Power BI Desktop. Once deployed to the Power BI Service it would be a regular click to launch the link.
Thanks Delvin. The link actually doesn’t work at all in Power BI Desktop (even if you hold down CTRL). It is only when you publish it that it partially works by holding down CTRL (or SHIFT if you want it to open a new window) and clicking the link. I am publishing to a Power BI Report server, if that makes any difference. Regards, Nick
Is it possible to place youtube links, embedded youtube, or maps or something similar? Thanks
I haven’t pushed the limits of this too much yet but you can definitely do links.
Hi Devin, this is for hyperlinks problem too. I think “Ctrl + Click the link” works for Chrome, but not for either Edge or IE. In Edge or IE when I click the hyperlink, there’s error message “This content can’t be shown in a frame…balabala…” Can this be fixed or is there any workaround? Thanks.
Thanks for this visual, can anyone have a solution to display HTML from a measure.
Hello, still same issue as Nick/Stone noted long ago — any way yet to open standard hyperlinks displayed in htmlViewer from Power BI service (other than CTRL-click when using Chrome only)? Thanks, JC
Sorry all! My notifications of comments seemed to be going to a retired email address. As many of you have noted this is not possible with this visual. I’d recommend contacted the the developer for potential updates.