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)
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)
thank you very much AnonymousPerson I'll give it a try
AnonymousPerson it works for me also
it's a bug at the end of the day
This is the answer I needed, thanks AnonymousPerson!
Had this problem on Windows 11 fresh install and the newest SSMS 19.1.56.0 when connecting to Azure Analysis Services. Trick with MS_AS_EnforceAdalUsage fix the issue. Thanks a lot AnonymousPerson!
