Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
willclein
Helper I
Helper I

Disable Table Refresh

I'm trying to disable refresh of a table that connects to a view in a SQL DB that is currently having issue. When I uncheck "Include in Report Refresh" and click "Close & Apply", Power BI attempts to "evaluate" the table which causes it to query the view even though I disabled refresh.

 

How can I disable this refresh so that I can just use the data as it currently is in the report while the DB issue is resolved?

3 REPLIES 3
amitchandak
Super User
Super User

@willclein , At the time close and apply it do check for data sanity for the changes which are done.  You can refer to this blog, there are few more tips provided there if those can help https://www.thebiccountant.com/speedperformance-aspects/

@amitchandak thanks for the link! I'll try some of those tips and let you know if it works.

Greg_Deckler
Super User
Super User

@willclein Not certain there is a solution for that exactly.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.