Forum Discussion
Gateway connection for analysis service
I added a gateway connection to the analysis service SSAS Multidimentional Cube, but in Windows authentication mode, it is asking for a username and password.
In Windows Authentication mode, you don't need to provide a separate password because it relies on your Windows credentials to authenticate you. How can I overcome this issue?
1 Reply
Hey JatinV ,
you can't.
Make sure that the account you provide here is a service account with administrative permissions on the SSAS Analysis Services Instance, being an Administrator on a model/database is not sufficient.
Make sure you are following this article: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas?WT.mc_id=DP-MVP-5003068
My recommendation is to use "Active Directory Lookup Mapping", this method works flawless in our organization.
Regards,
Tom
