Power BI report show report via HTML with help powerautomate

[sinanalmac]

Hi all,

I don't have an embedded license for Power BI online services. I want to Save the power BI report's picture to a folder every 5 minutes  with  power automate and I want to show this image via HTML web page every 5 minutes refreshment.

Is there any Idea about this method or is there any different method about this?

is there any one who did try this kind of thing?

Please help me.

Thank you

[ibarrau]

Hi. I don't think that would work. A static picture of a report can be confusing for a user. I would suggest you to involve your users on PowerBi. That way they can use it at the web portal. Even if you could build the solution, consider that you can't refresh every 5 minutes because non premium imported datasets can only refresh up to 8 times a day. That's why it's also better to embed instead of just inserting a picture. The user interaction will help them explore data.

Just for the heads up, there are three ways of embedding and only one of them requires the Embedded licence. The following two won't need capacity:

- Embed on web portal secure link:https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web

- Publish to web (unsecure don't use it with sensitive data): https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web

I hope that helps,

[sinanalmac]

Hi @ibarrau 

Many thank you for  your  reply. 

we are using power bI  streaming dataset in our report ( ex. https://www.youtube.com/watch?v=rjXJ0GSUMBg)

We are unable to use the Publish to web feature because our data is sensitive. we will display our reports on  meeting room Tvs and our company policy does not allow the use of static passwords.  it will change every 3 months for each user. We're trying to find a simple way to show our PBI report on the Meeting room TV.

Since we are using a streaming dataset, we thought if we could save report's image to a folder every 5 minutes with a flow and see it in a refreshing HTML page.

The setup like this : Every time a new image is saved from flow the HTML page will refresh the report image it shows
At least I think it will be like that. 

Best regards
Sinan 

[ibarrau · Accepted solution]

Again my opinion is to go for embed with secure code. There are to many variables on your idea of solutions that I don't think are going to work. I would prefer login each 3 months. IT department should understand the idea of a Service Account without expire date because even refreshing data will need it to work everytime if you are connecting to a source data requires AD to login. Like Sharepoint.

The problem with your solution is licence. You can "Export report to file" with the API to export a PNG. The issue is that the request requires dedicated capacity (premium or embedded). You can check the request here:
https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group

I hope that make sense