Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
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?
@bcdobbs ys working on latest SSMS
@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.
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.