Forum Discussion
Helper IError on scheduled refresh code":"DM_GWPipeline_Gateway_MashupDataAccessError"
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.
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 Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.