While trying to use Dataverse connector inside Power BI Desktop
we got the below error
Details: “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. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)”
Later we realized we were not entering the environment details in the correct format as expected
We were entering it incorrectly below with the https
Entering URL in correct format fixed the issue for us.
In case if TDS endpoint it not enabled –
we will get the below error
i.e. Microsoft SQL: TDS Protocol endpoint is disabled for this organization.
Check more posts on Power BI
Hope it helps..