Forum Discussion
Data Gateway (DM_GWPipeline_UnknownError)
- Anonymous2 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.
Just and update:
In order to try to solve the problem, I have upgrade my things to this (but the same problem shows):
datagateway: 3000.222.5 (May 2024)
SSAS: BUILD 16.0.1000.6
SSIS: BUILD 16.0
SSMS: 20.1
SQL Server: Microsoft SQL Server 2022 (RTM-GDR) (KB5035432) - 16.0.1115.1 (X64) Mar 15 2024 01:13:46 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 19045: )