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

gauge and bullet chart not updating automatically

Hi

The gauge and bullet charts are not updating automatically. I have to click refresh manually each time when I open the report. Can anyone help me with this issue?

 

many thanks

11 REPLIES 11
Highlighted
Super User IV
Super User IV

@czheng - That doesn't sound correct. Are these built in visuals or third party visuals? Maybe try Reset to default to clear personal bookmarks?


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Highlighted

Hi Greg, they are 2 visuals as below......it behaves the same with different browser and happens to other users as well. Other visuals like matrix are ok.

 

czheng_0-1599616560174.png

 

Highlighted

@czheng - Maybe a temporary hiccup with the Service. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Highlighted
Community Support
Community Support

Hi @czheng ,

You mean that the data in other visuals was updated except the gauge and bullet chart after schedule refresh completed? It happened in Power BI Desktop or Power BI Service? Whether the gauge and bullet chart be pinned to any dashboard? Could you please provide some screen shots with the old data and updated data (mask the sensitive data)? Thank you.

Best Regards

Rena

Highlighted

Hi @yingyinr 

 

Yes, other visuals are updated except the gauge and bullet chart (bullet chart by OKVIZ) after scheduled refresh. they are on Power BI service. Both gauge and bullet chart are pinned to the dashboard. And the error "Some of the dashboard tiles didn't load......Show details" is displayed on the mene of dashboard.

I don't know how to send sreenshots.

 

Thanks

Cathy

 

Highlighted

czheng_0-1600119844722.png

czheng_1-1600119886998.png

 

czheng_2-1600119902714.png

 

first screenshot is from dashboard, second is from report and last one is updated data

 

@yingyinr 

 

would very appreciate if you can help as the issue has been annoying us for a while.

 

Highlighted
Community Support
Community Support

Hi @czheng ,

You can click "Show details" to review which tile didn't be loaded into dashboards and check if it exist the following situations:

1.  Any visual applied RLS?

2.  Many visuals be pinned to one dashboard?

3.  Check data source and connection type

About the problem of gauge and bullet chart didn't refresh, it need to wait about 10-15 minutes for a refresh to be reflected in the dashboard tiles as written in this documentation. Or you can pin an entire report page to dashboard as an alternative. When you pin an entire page, the tiles are live.

Best Regards

Rena

Highlighted

Hi @yingyinr 

Thanks for your reply but what is RLS?

Those failed ones are connected with the reports which use live connection of our data cube.

 

I have to click "refresh dashboard tiles" manually under that 3 dots so that that error would disappear.

 

Regards

Cathy

 

 

 

Highlighted
Community Support
Community Support

Hi @czheng ,

You can review this official documentation to know the details of RLS

For dashboard tiles based on Direct Query/Live connection datasets, Power BI maintains a cache for every tile visual on your dashboards and proactively updates the tile caches when data changes. By default, the dashboard tile cache is refreshed once every hour. Owner of these datasets can change the schedule in the dataset settings to occur as frequently as every 15 minutes or force a dashboard update manually by using the Refresh Now option. You can find the deatils in the following link:

Datasets in DirectQuery/LiveConnect mode

schedule cache refresh.JPG

Best Regards

Rena

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors