Forum Discussion
Gateway live SSAS tabular connection error
Hi henripalmroth,
In your scenario, please check if the email address signed in the Power BI Service matches a defined UPN within the local Active Directory domain. You can take a look at this article: Map user names.
Also please try to create a report in Power BI Desktop, publish to service and set it use this data gateway, check if it can be refreshed successfully.
Best Regards,
Qiuyun Yu
Hi v-qiuyu-msft and thanks for your reply.
I have tested few reports with no luck. Same error. There is no refresh as such becauser we are using live connection to SSAS tabular model.
Also when I try to run whoami /upn on SQL server it will give me the correct answer which is [email protected]. So the effectiveusername should match what we have on local AD.
Br,
Henri
I have the same problem, have they solved it?
GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
InnerType=AdomdErrorResponseException
InnerMessage=<pi>The following system error occurred: </pi>
InnerToString=<pi>Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The following system error occurred:
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect(Boolean toIXMLA)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.AdomdConnectionProvider.OpenConnectionAsync()</pi>I think that the final solution was to give enough rights for SSAS / Server / Gateway to access AD user information. You can try this with management studio. Connect to Analysis Services and use additional parameters "[email protected]". It should connect without errors if there are enough rights to access AD.