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

Dashboard tiles have huge delays rather than reports

Hi all, I've searched for this throught the forums but not found any similar behaviour. When scheduled refresh of reports ends and the report successfully refreshes, there's always from 5 to 10 minutes before dashboard tiles get the refresh as well. The behaviour have been there for some weeks and seems not related to report performance as this one gets updated.

 

The behaviour is on the mobile app as well.<br>

 

Just to be clear, the underlying report hasn't get changes for months.

 

Anyone has faced this kind of issue?<br>

Thanks in advance.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Memorable Member
Memorable Member

Hi @arcellie ,

 

This is not totally unexpected.  According to this article https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data 

"It can take Power BI up to 60 minutes to refresh a dataset, even once the sync has completed on your local machine and after you've used Refresh now in the Power BI service."

 

That same article also has a section on Tile Refresh.  Other articles also indicate that it can be 10-15 minutes before a refresh is reflected in dashboard tiles.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

View solution in original post

6 REPLIES 6
Highlighted
Memorable Member
Memorable Member

Hi @arcellie ,

 

This is not totally unexpected.  According to this article https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data 

"It can take Power BI up to 60 minutes to refresh a dataset, even once the sync has completed on your local machine and after you've used Refresh now in the Power BI service."

 

That same article also has a section on Tile Refresh.  Other articles also indicate that it can be 10-15 minutes before a refresh is reflected in dashboard tiles.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

View solution in original post

Highlighted

Thanks @collinq !

So if I understand correctly, the behaviour can be triggered by too many tiles on the dashboard or RLS in SSAS (cache issue), correct?

I'm not able to see any cache options in the portal settings, is it a feature for Premium users only?

 

Thank you very much.

Highlighted

Hi @arcellie ,

Do you mean that you can't find "Scheduled cache refresh" section of the Datasets tab? If yes, please check the connection mode of your dataset. If the datasets in import mode, this section will not be available. It will display when the datasets are in DirectQuery/LiveConnect mode. However, if I misunderstand your question, please correct me and provide more detail. Thank you.

Announcing Custom Cache Refresh Schedules in the Power BI Service

Scheduled cache refresh.JPG

Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

Highlighted

Hi @yingyinr ,

actually I've that options and they're configured. 

I was referring to this one, but I premuse it's related to the connector used:

 

arcellie_0-1603098474603.png

 

Today refresh time was reduced than usual. I can suppose it could also be affected by some network circumstances.

Thank you very much for your help.

Highlighted

Hi @arcellie ,

Thanks for your feedback. Yes, the section "Query Caching" is only available on Power BI Premium or Power BI Embedded. You can find the details in the following documentation.

Query caching in Power BI Premium/Embedded

Best Regards

Rena

Highlighted
Frequent Visitor

Hi all,

just a brief update: Microsoft informed us about a global Known Issue which is causing defects in dashboard tiles refresh. The worldwide fix was scheduled for November 22th, but it has been rescheduled for the second week of December. 

 

The actual workaround seems to be only the manual refresh, however it doesn't seem to affect correctly every user on Desktop and moreover on mobile app.

 

We hope to solve this soon. 😞

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