Views:

Applies to Product - Dynamics 365 Business Central

What’s happening?
When attempting to connect Power BI Desktop to Dataverse, users encounter an error indicating "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.". When this error message occurs, the connector fails to connect to the TDS endpoint.


Reason:

  • Incorrect instance name for the Dataverse TDS endpoint. This can occur when the URL used with the connector includes https:// and/or the ending /.
  • Network issues that block communication between Power BI Desktop and Dataverse
     
Resolution:
  1. Verify that the SQL Server instance name in the Power BI data source settings matches the Dataverse environment you are trying to connect to.
  2. Ensure that SQL Server is configured to allow remote connections.
  3. Check for any firewall rules or network configurations that might be preventing a connection to SQL Server.
  4. Validate that there are no resource limitations on the SQL Server or the network that could be causing a timeout during the connection attempt.
  5. Ensure that the TDS endpoint is enabled for your Dataverse environment.
  6. Ensure that the TDS endpoint name is correct for you Dataverse environment and does not start with "https://" or end with "/" so that the URL looks like orgname.crm.dynamics.com
  7. Attempt to connect to the Dataverse using other tools or from a different network to rule out any issues specific to Power BI Desktop or the current network.
  8. Investigate any recent changes in network policies or updates to the Power BI service that could affect connectivity.
  9. Review the Power BI Desktop logs for any additional information regarding the connection failure.
For further details, refer to the following resources: - TDS Settings - Power BI Dataverse Connector