Post

Skillwave Training
@skillwave.training

An recent AKA attendee described a puzzling issue: queries driven by dates in worksheet cells kept showing old values after a refresh. Only clicking Refresh Preview, or saving, closing and reopening the file, seemed to fix it. 🤔 @excelguru.ca's diagnosis? The data probably wasn't wrong at all. 🧵

Skillwave Training
@skillwave.training

#PowerQuery caches preview values inside the file, so the Query Editor and hover cards can show stale results even after Refresh All has loaded fresh data to the worksheet. 🔄 It's even more likely if background data previews have been turned off to speed up large workbooks.

Skillwave Training
@skillwave.training

💡Ken's habit is simple: the first step in any debugging session is clicking Refresh Preview, then checking the loaded output before deciding something is broken. 🧭Takeaway: Refresh the preview before you trust what the Query Editor is showing you. #DataPreparation #BusinessIntelligence

Skillwave Training
@skillwave.training

A quirk like this can eat hours when you're on your own. In the AKAs, you get the reason behind it, so you can fix it with confidence and move on. Sign up at skw-t.com/aka, or get access for free with either our #Excel Fundamentals (skw-t.com/excelfun) or #SelfServiceBI (skw-t.com/ssbi) Academies.

skw-t.comAsk Ken AnythingGet access to an expert who will help you build real world solutions. The Ask Ken Anything (AKA) sessions are live, interactive coaching calls that are held twice each month. They’re designed to give…

0 reposts0 likes

No replies yet.