Forum Discussion
Connecting to Server models with SSMS through XMLA
Hello,
When following the steps in this https://docs.microsoft.com/en-us/power-bi/admin/service-premium-connect-tools#initial-catalog to connect to my premium capacity workspace using the XMLA endpoint, I get the errors below in SSMS when tying to login or whe specifying the Initial Content. Does anyone know why this is?
Login
TITLE: Connect to Server
------------------------------
Cannot connect to powerbi://api.powerbi.com/v1.0/myorg/Mozaic.
------------------------------
ADDITIONAL INFORMATION:
The integrated security 'ClaimsToken' is not supported for native connections. (Microsoft.AnalysisServices.AppLocal.AdomdClient)
------------------------------
BUTTONS:
OK
------------------------------
Initial Content
TITLE: Browse Server for Database
------------------------------
The integrated security 'ClaimsToken' is not supported for native connections. (Microsoft.AnalysisServices.AppLocal.AdomdClient)
------------------------------
BUTTONS:
OK
------------------------------
Hi Anonymous ,
Is it the latest version of SSMS? Please try updating SSMS to see if the problem still exists.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Anonymous ,
Is it the latest version of SSMS? Please try updating SSMS to see if the problem still exists.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.You need to login via "Azure Active Directory - Password", then specify your company email address and then NOT specify your password (yeah, right? Weird stuff). Then hit connect, get authenticated via your company's authentication process, and then you're connected.
