Showing results for 
Search instead for 
Did you mean: 
New Member

Power BI analysis Services Connector



I was setting up Power BI Analysis Services Connector. I downloaded power BI analysis on the server and installed it. After the install, I logged into power BI after which it asked me to enter server name and log on details. I was able to log in successfully, next it asked me for a friendly name and message , which I entered, but got the below error. Has anyone seen this type of error?Can anyone help me with this? 




Advocate V
Advocate V


Hi @ven7939



Make sure that on your SSAS server outbound ports: TCP 443 (default), 5672, 9350, 9354 are opened and all prerequistes validated. The check list is available at


By the way, you can test locally from the computer the AS Connector is installed on by:

  • Using whoami/UPN: From a command prompt, type 'whoami/upn'. If the return result doesn't match the e-mail address used with the Power BI account, the AS Connector won't work.
  • Using SSMS: In SQL Server Management Studio (SSMS), in the connect to server dialog for Analysis Services server, choose 'Options>>'

Then in the Additional Connection Parameters set EffectiveUserName= or the result of the whoami/upn). Then click Connect.

If connecting to the Analysis Services Server does not work, then the AS Connector will not work either.


For more information read


Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors