High severitydata source
Power BI Refresh Error:
DM_ErrorCode_Connection_TestFailed
What does this error mean?
Power BI could not establish a connection to the data source when testing connectivity. This error typically appears when configuring a new data source or when an existing connection breaks.
Common causes
- 1The server name or database name in the connection string has changed
- 2The data source server is not reachable from Power BI Service (cloud) or the gateway machine
- 3Credentials entered during connection setup are incorrect
- 4SSL/TLS certificate mismatch or untrusted certificate on the data source server
- 5The data source requires a gateway but none is configured or the gateway is offline
How to fix it
- 1Go to the dataset settings in Power BI Service and verify the data source connection details
- 2If using a gateway, confirm the gateway is online (green status) in Manage gateways
- 3Test the exact connection string in a desktop tool (e.g., SSMS, DBeaver, or Power BI Desktop) from the gateway machine
- 4Check whether the data source server's SSL certificate is valid and trusted by the gateway host
- 5If the server name recently changed (e.g., due to migration), update the connection in Power BI Desktop and republish the dataset