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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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
Employee
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
Employee
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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Top Solution Authors
Top Kudoed Authors