Forum Discussion

henripalmroth's avatar
henripalmroth
Regular Visitor
9 years ago

Gateway live SSAS tabular connection error

Hi,   We are not able to connect from Powerbi.com live SSAS tabular connection using gateway. Here are some backgroud details:   - SQL Server 11.0.6020 - Gateway is the latest downloaded today (...
Need Help
Victor_SotoG's avatar
Victor_SotoG
New Member
9 years ago

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>

 

 

henripalmroth's avatar
henripalmroth
Regular Visitor
9 years ago

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.