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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
cren
Frequent Visitor

Is there a way to have dashboards on app.powerbi.com visually update without a manual refresh?

Hello All,

 

I have recently been experimenting with trying to find the optimal way to create a real-time dashboard (or one that simply updates rather frequently when new response data arrives into my survey dataset). I have found streaming API to not be effective enought as I can´t enter the data editor. So instead, I decided to use an on-premise datagateway and have my dataset automatically refresh every 30 minutes. This has been working just fine thuse far as I have checked the scheduled refreshes.

 

The problem now is that it would appear that the visuals in my reports (and my dashboards) aren´t changing without a manual refresh. I try clicking to another report and clicking back and see no change. Even leaving the page and reloading it later does not change it. I need to actually manually refresh the my dashboard to see the new changes in the data reflected. Is this normal? I read that they should update automatically every 15 minutes. Am I not waiting long enough? I am using Google Chrome if that helps and I have heard previously that some people have used scripts on other browers.

 

Any information, or more importantly advice would be much appreciated on how to resolve this issue. Having the auto-refreshing, but being forced to manualy click the refresh button seems to defeat the purpose of scheduling the refresh to begin with.  I just don´t want a client to be confused if they expect for results to be in and reflected in the dashboard visuals, only to see nothing, especially later when I plan in the future to embed it into a website. 

 

Thanks

1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @cren,

 

Once you have configured gateway for dataset and set scheduled refresh for it. Any visualizations in your reports or dashboards based on the data are updated automatically.

 

In your scenario, what is the data source you configured scheduled refresh for?

Please refesh the web page manually to see whether dashboard is updated. Also, clear the cache of web browser and test again, as usually, web page would show you the cache data rather than the latested version without refresh it manually.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @cren,

 

Once you have configured gateway for dataset and set scheduled refresh for it. Any visualizations in your reports or dashboards based on the data are updated automatically.

 

In your scenario, what is the data source you configured scheduled refresh for?

Please refesh the web page manually to see whether dashboard is updated. Also, clear the cache of web browser and test again, as usually, web page would show you the cache data rather than the latested version without refresh it manually.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

It´s a googlesheets spreadsheet that is continously updated by SurveyMonkey as more respondents finish the survey. This is the web data source that I am using.

 

Interestingly, when I cleared the cache of chrome like you recommended and I refreshed the web page it worked. Do I have to do this every time? It´s not really as important for me, but rather for the client at the moment. For example, if my client turns on his/her computer once or twice a day, I want the dashboard I shared to show the most recent data possible. Will this function correctly on their computers? 

 

Thanks very much for your response!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.