Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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". 😉
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.