Forum Discussion
Data Gateway (DM_GWPipeline_UnknownError)
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.
Hi, HurleyWave
Thank you very much for your reply. I saw the picture you provided, and on the management gateway connection interface, you get an error:
1. There was an error while saving. An error occurred while trying to save the changes,
2. There was an error accessing the data source and it is recommended to contact the gateway administrator
I see that your gateway is online, you can check if your data source is online:
When you share the dashboard with other users:
All resources are busy. Please try again and refresh the gateway
This error indicates that the dashboard resources you are trying to access are overloaded. Does your dashboard have many tiles that cause the gateway to be exceeded. Can you set up a dashboard with only one or two visuals to test if the current problem is caused by too many visuals being displayed in one dashboard.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
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.
Hello Anonymous ,
thank you for your replying, And you were right, I have a problem with the analysis service connection, it asks me to enter credentials, but I have no authentication method other than "Widows without representation", how can I change that?
Hi, HurleyWave
Thank you very much for your reply. You can re-establish a gateway connection in Power BI Service and configure that semantic model to your new gateway connection, you can refer to the following tutorial:
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.
Hello Anonymous ,
Thanks again for the interactions, they were very useful.
Unfortunately, even following the tutorial you've indicated, I'm still having problems changing the authentication method. The problem is with the personal gateway. It's online (as you can see in the images) but I can't create another connection with the same gateway, but with the right authentication method. The session id is "7ccff52b-3587-4c29-a5bd-76deb086bb69"I can only create a gateway from the enterpise gateway, which doesn't solve anything since it's operational.
Is there any other way to change the authentication method, such as changing a file with a .dll or .config extension?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.