Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kdassani
Frequent Visitor

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:

 

kdassani_0-1674468893936.pngkdassani_1-1674468926515.png

Kindly help.

 

1 REPLY 1
bcdobbs
Super User
Super User

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:

bcdobbs_0-1674472813246.png

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.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors