Forum Discussion
SSMS 19 Bug - Error logging into XMLA Endpoint
I have resolved the issue with the help of the Microsoft Power BI support team. You need to create an environment variable on your Windows PC (easiest way is to type "Edit the system environment variables" in the Start menu).
The variable should be named "MS_AS_EnforceAdalUsage", and the value should be set to "1". Then restart SSMS 19, and login to Power BI XMLA endpoint works.
The support engineer said this is a bug in SSMS and will be fixed in the next update to SSMS 19 (current at time of writing is 19.0.1)
Hi GilbertQ
I tried running SSMS 19 as an admin and logging into the XMLA endpoint.
I do it exactly the same way in SSMS 18 and SSMS 19.
In SSMS 18 I can log right in (after passing MFA)
In SSMS 19 I get the error:
TITLE: Connect to Server
------------------------------
Cannot connect to powerbi://api.powerbi.com/v1.0/myorg/Operations.
------------------------------
ADDITIONAL INFORMATION:
Unable to obtain authentication token using the credentials provided. (Microsoft.AnalysisServices.AdomdClient)
------------------------------
There was an error parsing WS-Trust response from the endpoint. This may occur if there is an issue with your ADFS configuration.
Can anybody verify that XMLA endpoint is working in SSMS 19? I've scoured the documentation and I don't see anything about any breaking changes or known limitations in SSMS 19. It's weird.
We also experience the same problem access PPU endpoints using SSMS 19.0 (as admin or otherwise). We're not running Premium Capacity so can't comment on that.
EDIT: Just adding that we get ADFS related messages for SSMS 19.0 as well and, like the above, we don't use ADFS.