Forum Discussion
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.
- Anonymous2 years ago
Hi Morrison ,
Here are some steps you can take to troubleshoot this issue:
1. Verify the SQL Server Name: Make sure that the SQL Server name you're using in your Power BI project is correct. The server name should be in the format `servername\instancename`.
2. Check SQL Server Configuration: Ensure that your SQL Server is configured to allow remote connections. You can do this by following the steps in this https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-access-server-configuration-option?view=sql-server-ver15
3. Check Network Connectivity: Try to ping your SQL Server from the machine where you're running Power BI to see if it's reachable. If you're unable to ping the server, you might have a network issue that needs to be resolved.
4.For specific errors, you can refer to the documentation:A network-related or instance-specific error occurred - SQL Server | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- AnonymousNot applicable
Hi Morrison ,
Here are some steps you can take to troubleshoot this issue:
1. Verify the SQL Server Name: Make sure that the SQL Server name you're using in your Power BI project is correct. The server name should be in the format `servername\instancename`.
2. Check SQL Server Configuration: Ensure that your SQL Server is configured to allow remote connections. You can do this by following the steps in this https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-access-server-configuration-option?view=sql-server-ver15
3. Check Network Connectivity: Try to ping your SQL Server from the machine where you're running Power BI to see if it's reachable. If you're unable to ping the server, you might have a network issue that needs to be resolved.
4.For specific errors, you can refer to the documentation:A network-related or instance-specific error occurred - SQL Server | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.