Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Unable to connect server to SSMS Analysis services

Hello All,

I am trying to connect workspace connection (server) to SSMS Analysis services. But somehow its not taking my username Password.

I have tried authenticationg from all the three options (Windows Authentication, Azure Active Directory password and Universay with MFA). Here are the screenshots what i am trying to do:

 

Kindly help.

 

Need Help

1 Reply

  • bcdobbs's avatar
    bcdobbs
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi,

    A few thoughts...

    1) The server name needs to be in the form: powerbi://api.powerbi.com/v1.0/myorg/<Workspace Name>
    From the premium tab of workspace settings you can copy the URL:

    2) In order to connect a workspace must be in either Premium Per User or Premium Capacity.

    3) You need to make sure you have XLMA endpoints turned on in tennant settings.