Hi @Michael_Seerup ,
Based on your description, you are trying to connect to a data source on the dataverse and then are getting SQL Server connection errors. In order to resolve this issue, first you need to make sure that the SQL Server service is running on the host computer. And verify that SQL Server is configured to allow remote connections, you can check this under “SQL Server Network Configuration” in SQL Server Configuration Manager. Next, make sure the firewall on the server is allowing traffic on the SQL Server port. For the default instance, this is usually TCP port 1433, and for the named instance, make sure that the SQL Server Browser service is allowed through the firewall. Finally, check that named pipes and TCP/IP protocols are enabled in SQL Server Configuration Manager. If the above solutions don't work, you can try clearing the data credentials in power bi and reconnecting.
Here are a few possible causes and solutions:
1. You need to make sure that TDS endpoints are enabled for the dataverse, check if the URL contains https:// and/or the ending /, remove the https:// and the ending forward slash so that the URL is in the format orgname.crm.dynamics.com
2. verify the TCP ports 1433 or 5558 from the client are unblocked
Here is the documentation you can refer to for more verification steps
A network-related or instance-specific error occurred - SQL Server | Microsoft Learn
Create a Power BI report using the Dataverse connector - Power Apps | Microsoft Learn
Use SQL to query data (Microsoft Dataverse) - Power Apps | Microsoft Learn
Control access of the TDS endpoint - Power Platform | Microsoft Learn
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
