Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sinanalmac
Resolver I
Resolver I

Power BI report show report via HTML with help powerautomate

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

1 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


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

Happy to help!

LaDataWeb Blog

View solution in original post

3 REPLIES 3
ibarrau
Super User
Super User

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,


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

Happy to help!

LaDataWeb Blog

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 


 

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


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

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors