The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have got a power bi workspace with a semantic model in it. The workspace is in pro mode, thus no xmla endpoint should be available. Now, when connecting with tabular editor (TE) to the workspace, I get an error message, that I am not aloud to use the discover method. Works as expected.
Now, when I try the same with dax studio, I do can connect to the workspace and I get a list of available databases. When selecting my model, am perfectly able to connect to the model, get all the metadata and fire queries as it would be a local desktop model. What other endpoint apart from TE is DAX studio using and why am I able to connect without premium?
Hi @tareksalha ,
When you try to connect to your Power BI workspace in Pro mode using TE, you get an error because Pro mode does not support the XMLA endpoint, which is required for TE to perform metadata operations.
Please refer: Semantic model connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft...
DAX Studio is leveraging the Power BI Desktop local model connection, which doesn't require the XMLA endpoint.
Please refer: Getting Connected | DAX Studio
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
any idea regarding this topic?
Hi Neeko,
I am not sure, if I fully understand your answer. in the link, that you are referring to, it is clearly stated, that DAX studio is also connecting to workspaces via XMLA endpoint, see this abstract: Getting Connected | DAX Studio
Thus, I still do not understand the difference.
Besides, from further testing I can confirm, that while I am able to connect, I am not able to use DAX Studios full functionality. For instance, it is not possible to run the view metrics command