Power BI Gateway not working for Analysis Services, but working for SQL Server

[EmileDiedrick]

Power BI Gateway connections stopped working for Analysis Services. Working for SQL Server connections.

Tested Personal and Service Accounts and both have access, but neither works through the Gateway. Report Users cannot access reports with live connections.

[ichavarria]

Hi @EmileDiedrick,

I assume it is an Enterprise Gateway and not a Personal Gateway.  There could be various reasons why Power BI Gateway connections have stopped working for Analysis Services only. Here are a few things you can check to troubleshoot the issue:

1. Ensure that the Power BI Gateway is up to date. You can check this by logging into the machine where the gateway is installed and opening the gateway application.

2. Check if the Analysis Services instance is accessible from the machine where the Power BI Gateway is installed. You can use SQL Server Management Studio or another tool to test connectivity.

3. Make sure that the Analysis Services instance is configured to allow external connections. You can check this by going to the Analysis Services properties and verifying that "Allow remote connections to this server" is enabled.

4. Ensure that the Analysis Services firewall is not blocking incoming connections from the Power BI Gateway.

5. Check the credentials used for the Analysis Services connection in the Power BI Gateway. Make sure that they are correct and have sufficient permissions to access the Analysis Services instance.

6. Verify that the Analysis Services data source in Power BI is configured to use the correct gateway.

7. Check the logs for any error messages related to the Analysis Services connection in the Power BI Gateway.

If none of these steps resolve the issue, it may be helpful to contact Microsoft support for further assistance.

Best regards, 

Isaac Chavarria

If this post helps, then please consider Accepting it as the solution and giving Kudos to help the other members find it more quickly.