Forum Discussion

Morrison's avatar
Morrison
Helper I
2 years ago
Solved

Error on scheduled refresh code":"DM_GWPipeline_Gateway_MashupDataAccessError"

Hi,

i have a problem with scheduling a power bi project. When I try to update it from the web I get an error. In the Finaltable, I have a series of merge table queries that come from different sources. Could that be the problem? If so, how can I solve it? Thanks for your help

 

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":"Microsoft SQL: A network-related or instance-specific error occurred while creating a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured for allow remote connections. (provider: named Pipe Provider, error: 40 - Unable to open a connection to SQL Server)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value" :"-2147467259"}} ,{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"20"}},{"code" :"Microsoft.Data.Mashup .ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath" ,"detail":{" type":1,"value":"sy-tigdwh-dv.sql.XXX.net;BBB"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode" ,"detail":{" type":1,"value":"-2146232060"}},{"code":"Microsoft\.Data\.Mashup\.ValueError\.Message","detail":\{ "type":1," value":"A network-related or instance-specific error occurred while connecting to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Unable to open a connection to SQL Server)<\/ccon>"}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail": { "type":1,"value":"53"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":" DataSource .Error"}}],"exceptionCulprit":1}}} Table: FinalTable.

 

1 Reply