Forum Discussion

AnonymousPerson's avatar
AnonymousPerson
Advocate V
3 years ago
Solved

SSMS 19 Bug - Error logging into XMLA Endpoint

Now that SSMS 19.0 has been released to the public, I continue to have trouble logging into the XMLA endpoint with SSMS. It works fine in SSMS 18. But when I try to log in to the XMLA endpoint in SSM...
Need Help
  • AnonymousPerson's avatar
    AnonymousPerson
    3 years ago

    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)

AnonymousPerson's avatar
AnonymousPerson
Advocate V
3 years ago

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)

BillColeman77's avatar
BillColeman77
Frequent Visitor
3 years ago

This is the answer I needed, thanks AnonymousPerson!