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

Reports and dashboards not visually updating after a scheduled data refresh

Hello All,

 

I have recently been experimenting with trying to find the optimal way to create a live (or at least very frequently updated) dashboard of survey data for prospective clients. I have found streaming API to not meet all the expectations enough, so I have recently tried using a different method. Using a google sheet, I continously add data from SurveyMonkey and then from Power BI Desktop I used this as a Web data source to create a report. I subsequently published it to Powerbi.com and made a dashboard.

 

Then on the web service, I set up my datagateway and scheduled a refresh every 30 minutes for my googsheets web data that was automatically added to my workspace after the publishing. 

 

The problem now is that my dataset appears to be refreshing just fine (I saw the scheduled refreshes and got no error emails), but 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 report as well 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? 

 

Any information, or more importantly advice would be much appreciated. 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.

 

Thanks

 

 Captura.PNG

Note. I know that the refresh doesn´t finish exactly the moment I specify. But as shown here, it was was finished about 13 minutes after 3:00pm. I checked my report a few minutes after that time and saw nothing change.

1 ACCEPTED SOLUTION

Accepted Solutions
Ross73312 Super Contributor
Super Contributor

Re: Reports and dashboards not visually updating after a scheduled data refresh

From what I understand, the only option is the get them to hit the refresh button in the bar at the top, or cause the browser to initiate a refresh.  We are undertaking a project to display Power BI reports on TVs, and one of the potential solutions maybe to use a google chrome script to cause the page to refresh on set intervals.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


View solution in original post

5 REPLIES 5
Ross73312 Super Contributor
Super Contributor

Re: Reports and dashboards not visually updating after a scheduled data refresh

From what I understand, the only option is the get them to hit the refresh button in the bar at the top, or cause the browser to initiate a refresh.  We are undertaking a project to display Power BI reports on TVs, and one of the potential solutions maybe to use a google chrome script to cause the page to refresh on set intervals.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


View solution in original post

Highlighted
sampathkumar Frequent Visitor
Frequent Visitor

Re: Reports and dashboards not visually updating after a scheduled data refresh

Hello cren ,

which browser you are using. Please go with Google Chrome let us know still if you are facing issue.

JamesDanielBest Occasional Visitor
Occasional Visitor

Re: Reports and dashboards not visually updating after a scheduled data refresh

Hi there,

 

Did you find a solution to this?

 

Thanks,

James

cren Frequent Visitor
Frequent Visitor

Re: Reports and dashboards not visually updating after a scheduled data refresh

Hello Sampath,

 

Thank you for your reply.

 

I am using Google Chrome as my browser. It is strange, I can tell that the dashboard is trying to update, but it won´t without a manual refresh. If I open a new tab, go to powerbi.com and click on my dashboard, it flashes for a moment the updated data in the visuals. However, then it just reverts and I need to manually click refresh on the bar.

 

This is different than API streaming where my dashboard will visually update without any form of refreshing of even the page.

cren Frequent Visitor
Frequent Visitor

Re: Reports and dashboards not visually updating after a scheduled data refresh

Hello Ross,

 

Thank you for taking the time to answer my question. Sorry for the late reply, this past weekend was a national holiday in Argentina.

 

Does microsoft or any other reputable source have tutorial on how to use a google chrome script? I have never done something of this nature and would like to learn how I can use it for this particular challenge/problem. Is it a rather elementary process? Any links or further information would be much appreciated.

 

Thank you once again.

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

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: 319 members 3,019 guests
Please welcome our newest community members: