Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Error configuring the Power BI Analysis Services Connector

Hi, I am trying to set up the Power BI Analysis Services Connector to connect to Tabular Data... However on the screen where i "Connect to the SQL Server Analysis Server after i put in the Server Name and the Windows User Name and Password i get the following error:


"One or more error occurred when accessing the host service. error message: forbidden."


I am using the latest version of the connector. I can connect to the Tabular Data directly from Power BI Desktop using the same windows credentials.

Responsive Resident
Responsive Resident



2 Recommendations:
1. Check whether the ports get opend for the connector or you have a restriction there.

2. I would propose to use the Enterprise gateway instead of the AS Connector, as the AS Connector is not the "thing of the future". 😉

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

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.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors