cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate I
Advocate I

Looks Like the Refresh Button in Power BI Service Report View Refreshes the Dataset as well

Hi Everyone,

 

It has been a while that I have been tracking to see if the Refresh button in Power BI Service report view only refreshes the tiles (as suggested in a 2017 post) or whether it starts an on demand refresh on the whole dataset. I appreciate any insights or suggestions on this.

 

Based on my experience, it looks like the whole dataset goes through a refresh. Now if that's the case, it creates an issue, preventing me from publishing an updated file as I'm developing the report in Power BI desktop. 

 

Based on tracking the refresh history, it looks like whenever anyone with access to the report hits the refresh button, an on demand refersh happens which seems totally random, it is happening outside the scheduled refreshes and during the time where I have not attempted any republishing to trigger the refresh process. 

 

I would appreciate your guidance on this.


Thanks.

1 ACCEPTED SOLUTION
Community Support
Community Support

Hi @sraissi ,

When refresh tiles from a import mode datasource, power bi will update tile data from cached datasets, it not triggered on demand refresh.

For live mode datasource, it will update each time you interact with visuals, I think it may triggered the on demand refresh.

Data refresh in Power BI

When you interact with a visualization, queries are sent from Power BI directly to the database. Updated data is then returned and visualizations are updated.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support
Community Support

Hi @sraissi ,

When refresh tiles from a import mode datasource, power bi will update tile data from cached datasets, it not triggered on demand refresh.

For live mode datasource, it will update each time you interact with visuals, I think it may triggered the on demand refresh.

Data refresh in Power BI

When you interact with a visualization, queries are sent from Power BI directly to the database. Updated data is then returned and visualizations are updated.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Hi Xiaoxin,

 

Thank you very much for your response. So, this could be that for report with a dataset based in a cloud space (like Salesforce), anytime a report viewer hits the refresh button, it could trigger an on demand refresh. Did I understand it correctly?

 

And if this is the case, is there any way to limit this option as it interferes with developing and republishing?

 

Thanks.

For your reference, I have included this image from the ribbon in Power BI service as well as the options I get when pressing the ellispis.

 

I followed the link included in your response to the description on data refresh but I don't get the "refresh tiles" option as separate. All I get is one refresh button as in the picture, and so does every one else who views/interacts with the report.

 

Thanks.Ribbon.PNG

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors