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: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
smpa01
Super User
Super User

How to refresh Local Cache of SSMS IntelliSense for SSAS queries

‎01-18-2022 08:16 AM

@bcdobbs 

Does anyone know, how to refresh the local cache of SSMS's IntelliSense for DAX queries?

For TSQL queries the option is there as well as the shortcut. For SSAS queries, I don't see anything.

It is driving me crazy. Is there a workaround?

smpa01_0-1642522093824.png

 

smpa01_2-1642522560728.png

 

 

 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
Labels:
Message 1 of 4
2,446 Views
0
3 REPLIES 3
v-janeyg-msft
Community Support
Community Support

‎01-20-2022 11:26 PM

Hi, @smpa01 

 

I'm not good at T-SQL but I think this feature might not support DAX queries.

Reference:

How To Refresh Intellisense Cache In SQL Server (tech-recipes.com)

vjaneygmsft_0-1642749882749.png


Best Regards,
Community Support Team _ Janey

Message 4 of 4
2,372 Views
0
bcdobbs
Community Champion
Community Champion

‎01-18-2022 08:56 AM

My first thought was surely CTRL-SHIFT-R just works... but no you're absolutely right it doesn't at all. Just spent 10 minutes playing with it and I can't work out out how to force it!



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Message 2 of 4
2,401 Views
0
smpa01
Super User
Super User
In response to bcdobbs

‎01-18-2022 09:43 AM

Thanks for trying. This is a real issue. Since it is not updating, I don't know if I have a syntax error or they are just SSMS bug for cache not updating for SSAS queries.

 

Love DAX studio, but copy paste resulting table (for result validation) is a different level of trouble which on the other hand is no issue in SSMS.

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
Message 3 of 4
2,390 Views
0

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All