cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Weka Frequent Visitor
Frequent Visitor

Publish Dashboard to Web or Live refresh on web published report

Hi,

 

I need to publish to web while also having a live automatic refresh of the data and dashboard (or report).

I have a wall mounted screen which will display the dashboard or report by url in the browser (without logging in).

I seem to have come accross the following limitations.

 

Dashboard:

Live automatic refresh when the dataset refreshes.

Can't publish to web (users must log in to see).

 

Report:

No Live refresh, user has to click refresh manually even if the data set is refreshed.

Can publish to web and anonymous users can access.

 

Any suggestions on how to achieve this?  

 

It seems like it must be a common requirement.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Publish Dashboard to Web or Live refresh on web published report

Hi there

The caching is by design for Publish to Web reports, because they do not know how large the audience will be for these types of reports.

There is no way to change the caching. If you want it to update quicker, then you can use a Power BI Pro licensed account and that will refresh as soon as the underlying data changes.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Publish Dashboard to Web or Live refresh on web published report

Hi there

Those are the current limitations of publish to web.

What you could do, is to purchase a Power BI Pro license, which will then allow you to configure the above as required.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
Weka Frequent Visitor
Frequent Visitor

Re: Publish Dashboard to Web or Live refresh on web published report

I am using Power BI pro on trial and it does not seem to resolve the above limitations.

Super User
Super User

Re: Publish Dashboard to Web or Live refresh on web published report

Hi there

With your challenges above the reports will currently not auto refresh.

Only dashboard tiles will auto refresh.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
Weka Frequent Visitor
Frequent Visitor

Re: Publish Dashboard to Web or Live refresh on web published report

I managed to get around this by publishing the report to the web and then using a display service (piSignage) that refreshes the page at  a set time interval.

 

After the dataset is automatically refreshed in the background it takes the web published report somewhere between 30 minutes and an hour to update (or for PBI to stop caching it).

 

I can't seem to find any documentation on this caching of web published reports or how long it is for.  It would be nice to know the details.

Super User
Super User

Re: Publish Dashboard to Web or Live refresh on web published report

Hi there

The caching is by design for Publish to Web reports, because they do not know how large the audience will be for these types of reports.

There is no way to change the caching. If you want it to update quicker, then you can use a Power BI Pro licensed account and that will refresh as soon as the underlying data changes.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 51 members 1,058 guests
Please welcome our newest community members: