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
smpa01
Super User
Super User

Datamart issue

Is there a reason why Datamarts don't show up in SSMS for AS db but shows up in DAX studio.

 

I want to run XMLA query from SSMS on Datamart dbs which I can't do from DAX studio.

@jeffrey_wang @bcdobbs @AlexisOlson 

 

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
4 REPLIES 4
bcdobbs
Super User
Super User

Haven't done much with datamarts but will try and recreate the issue.

 

If you can connect with dax studio but not ssms it sounds like a library issue. Do you have latest ssms installed?



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!!

@bcdobbs ys working on latest 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

@smpa01 when you say data mart I'm assuming you mean the model that sits on top of the sql instance? Really sorry if this is a silly question but have you selected analysis services in the drop down when you first load ssms. It will default to SQL instant normally.



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!!

but have you selected analysis services in the drop down when you first load ssms - yes

 

I can run all sort of dax queries on the same datamart (AS db) in ssms; but they simply don't show up in the list of dbs. That is making my life difficult cause I simply want to run an XMLA query to check something in a db which is not downloadable as incemental factored in. So I want to initate some changes through XMLA

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

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.

Top Solution Authors
Top Kudoed Authors