Forum Discussion

Frequent Visitor

2 years ago

Solved

Data Gateway (DM_GWPipeline_UnknownError)

Hello, I'm trying to connect my SSAS with powerBI but i'm getting this error: GatewayPipelineErrorCode=DM_GWPipeline_UnknownError GatewayVersion= InnerType=AdomdErrorResponseException InnerM...

Need Help

Anonymous
2 years ago
Hi, HurleyWave

First of all, sorry for my late reply. Thank you very much for your reply. I looked up information like this, and when connecting to SSAS data sources, the Power BI gateway only supports Windows authentication.
The Windows account you enter must be a member of the Server Administrator role on the instance of Analysis Services you want to connect to. If the password for this account is set to expire, the user will receive a connection error unless you update the data source password.

You open the link below and use the method mentioned in the document to get your correct account number.

Manage SQL Server Analysis Services data sources - Power BI | Microsoft Learn

Best Regards

Jianpeng Li

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

Anonymous

Not applicable

2 years ago

Hi, HurleyWave

Are the server names, database names, and credentials that you are connecting to SSAS on Power BI Service correct? Are you able to connect to your SSAS properly on Power BI Desktop?

Secondly, you should make sure that the above information is correct and that the current account has the relevant read permissions. Based on the error you provided, it is indicated: AdomdErrorResponseException. It is also possible that the communication between the SSAS and the gateway is blocked.

You can check if the steps in the official documentation below are consistent with your steps:

Manage SQL Server Analysis Services data sources - Power BI | Microsoft Learn