Deciphering an error message

[ANDBMcD]

Below is the error message I'm receiving when trying to refresh my dataset. I can't seem to figure out what this error message is telling me is wrong. Is it a runtime issue? Is it having an issue with connecting to one my data sources? Please help!

There was an error when processing the data in the dataset.

Please try again later or contact support. If you contact support, please provide these details.

• Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AnalysisServices: The connection either timed out or was lost."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"AnalysisServices"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"kcm-sql-026\\sqlprd26;PMM"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: PMM - Canada.
• Cluster URIWABI-WEST-US-redirect.analysis.windows.net
• Activity ID1d73ebfd-5506-4254-9554-3eaa07f91fdc
• Request IDb2f3ccd7-583b-4b80-ad8a-b3b0a8d8bc34
• Time2020-04-14 15:49:14Z

[Anonymous]

Hi @ANDBMcD ,

Whether the problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help other members in the community find the solution easily if they face the similar problem with you. Thank you.

Best Regards

Rena

[Anonymous]

Hi @ANDBMcD ,

Which data source you are connecting to? And if configure any gateway? It seems the issue is caused by access failed to the data source... Please check if the solution in this thread can help you resolve the problem. 

Best Regards

Rena

[GilbertQ · Accepted solution]

Hi there

What the error message is saying is that it cannot connect the Analysis Services database.

Could you check if your Gateway server can connect to the analysis services database?

And if possible extend the timeout connection to the Analysis Services database in your data source setting