topic Re: Render a Paginated report as HTML while using Subscriptions in Service

Render a Paginated report as HTML while using Subscriptions

OrenHenig — Wed, 31 Mar 2021 14:29:17 GMT

HI all,

Power BI Paginated reports allows subscribing to a specific report to get the report by push to emails.

There are several options to render the report (PDF, CSV, docx, etc...).

I need to render the report as HTML in the email's body.

This was optional in SSRS and I couldn't find how to do so.

The closest I got is placing a PNG in the mail's body.

Any suggestions?

Thanks in advanced.

Oren.

Re: Render a Paginated report as HTML while using Subscriptions

v-robertq-msft — Mon, 05 Apr 2021 08:08:43 GMT

Hi, OrenHenig

As far as I’m concerned, you can only get the HTML code of the report in the “Share”->” Embed or publish in web” option in the Power BI service.

When you set the subscription for a report in Power BI, you can get a link that nevigate to this report, but you can not view and interact with the report within the email at current.

If you have an idea about this, you can also go to the Power BI Idea to submit a new idea so that people with the same idea can vote for you. I will also vote for you.😁

Thank you very much!

More info about “Publish to web from Power BI”

Subscribe others to your reports and dashboards in the Power BI service

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Render a Paginated report as HTML while using Subscriptions

AnonymousPerson — Fri, 04 Feb 2022 21:12:15 GMT

OrenHenig Did you ever find a way to embed reports as HTML in the body of an email using Power Automate? It would be very valuable to replicate this missing functionality from SSRS. The only reply here seems way off topic.

Re: Render a Paginated report as HTML while using Subscriptions

OrenHenig — Sun, 06 Feb 2022 07:55:11 GMT

No native way to do so.

Just export as MHTML to a file and then (progrematically) transform it into an HTML and add it to an email.

I didn't end up actually performing this, just planned it.

Re: Render a Paginated report as HTML while using Subscriptions

AnonymousPerson — Mon, 07 Feb 2022 15:41:17 GMT

This topic offers a legit solution. You have to save it as EML file, convert it to HTML, then clean up a bit.

Re: Convert MHTML to HTML or send formatted MHTML ... - Power Platform Community (microsoft.com)

Re: Render a Paginated report as HTML while using Subscriptions

OrenHenig — Tue, 08 Feb 2022 06:54:15 GMT

Thanks! looks good

Re: Render a Paginated report as HTML while using Subscriptions

michaelgutman — Tue, 14 Mar 2023 21:02:44 GMT

I got the table to load but on my paginated report I'm also running a graph and can't grab that image to load into email. I hope they add this feature in soon similar to SSRS.

Re: Render a Paginated report as HTML while using Subscriptions

michaelgutman — Wed, 15 Mar 2023 15:08:39 GMT

Please vote below for this to be a feature

https://ideas.powerbi.com/ideas/idea/?ideaid=74f8f291-3fad-4e22-b62e-73d5e8248d77