Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
willclein
Helper I
Helper I

Disable Table Refresh

‎09-15-2020 04:01 PM

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?

Labels:
Message 1 of 4
1,435 Views
0
3 REPLIES 3
amitchandak
Super User
Super User

‎09-15-2020 05:56 PM

@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/

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here
Message 3 of 4
1,397 Views
0
willclein
Helper I
Helper I
In response to amitchandak

‎09-16-2020 06:56 AM

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

Message 4 of 4
1,368 Views
0
Greg_Deckler
Super User
Super User

‎09-15-2020 05:03 PM

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



Follow on LinkedIn
@ 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!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Message 2 of 4
1,405 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All