Custom HTML Button to Print Embedded Report

Anonymous · ‎08-23-2023

I have quite a few embedded reports that users need to be able to click a button and print the full report. I have GCC so I cannot use Power Automate. I saw where I could add the "HTML Content" visual to add a customized print button. I added that then added the following measure for the visual:

HTMLButton =

"<html>

<head>

<title>Print Button</title>

<style>

.print-button {

background-color: #a0d1ff;

border-color: #118dff;

border-style: solid;

border-width: 3px;

color: black;

padding: 4px 30px;

text-align: center;

display: inline-block;

font-family: Segoe

font-size: 9px;

cursor: pointer;

margin: 4px 2px;

}

</style>

</head>

<body>

<div class='print-button' onclick='printReport()'><b>Print</b></div>

function printReport() {

var element = document.getElementById('report-container');

var report = powerbi.get(element);

report.print();

}

</script>

</body>

</html>"

The button looks great but when I click on it from within the embedded report, nothing happens. Any ideas how to fix this, or any ideas on how to print an embedded report?

dm-p · ‎08-24-2023

Hi @Anonymous,

HTML Content doesn't support scripting, and I don't have any plans to include support for this, as I can't supply any tools for debugging scripts if they fail. Custom visuals also have very limited abilities due to the sandboxing that Microsoft imposes upon them for security reasons, so there's a lot of Javascript that won't work and that can make it more confusing for anyone attempting to reproduce something inside it.

Also because custom visuals are sandboxed iframes, they don't know anything about the rest of the report. Even if you could action the print dialog via scripting, you would only be able to print the visual itself and not the rest of the visuals on the report page.

I'm not very familiar with Power BI embedded, but you would likely need to code the functionality to an element (e.g. a button) within the page that hosts your report. It looks like there is a print method that can be used. The folks that work with Power BI Embedded frequent the Developer forum on these community boards, so you may have more luck posting your request there.

Regards,

Daniel

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

On how to ask a technical question, if you really want an answer (courtesy of SQLBI)