Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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
Solved! Go to Solution.
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
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
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!
User | Count |
---|---|
36 | |
31 | |
20 | |
11 | |
8 |
User | Count |
---|---|
52 | |
42 | |
28 | |
12 | |
11 |