The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
User | Count |
---|---|
41 | |
23 | |
16 | |
15 | |
14 |
User | Count |
---|---|
89 | |
38 | |
26 | |
24 | |
19 |