On-Premise Gateway not Connecting the SSAS Data Properly
We recently created an on-premise gateway to connect to the analysis packs on the SQL server. Our system login credential does not match with SQL server login, therefore we have followed the instruction on this article (https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-ssas) and performed AD lookup mapping. After that, we were able to connect the the SSAS data source and be able to see the tables. But when trying to create tan visual, we have received the following error: "Couldn't retrieve the data for this visual. Please try again later. Please try again later or contact support. If you contact support, please provide these details."
Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: AdomdErrorResponseException:<pi>Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The following system error occurred: The name provided is not a properly formed account name.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
How to configure your gateway to perform the AD Lookup:
Download and install the latest gateway
In the gateway, you need to change theOn-premises data gateway serviceto run with a domain account (instead of a local service account – otherwise the AD lookup won’t work properly at runtime). You'll need to restart the gateway service for the change to take effect. Go to the gateway app on your machine (search for “On-premises data gateway”). To do this, go toService settings > Change service account. Make sure you have the recovery key for this gateway, since you'll need to restore it on the same machine unless you want to create a new gateway instead.
Navigate to the gateway’s installation folder,C:\Program Files\On-premises data gatewayas an administrator, to ensure that you have write-permissions, and edit the following file:
Edit the following two configuration values according toyourActive Directory attribute configurations of your AD users. The configuration values shown below are just examples – you need to specify them based on your Active Directory configuration.
Restart theOn-premises data gatewayservice for the configuration change to take effect.