Hello,
I am trying to add a data source (a Microsoft SQL Server) to the Power BI Service. The data source works fine w/ Power BI desktop, but when adding the data source on Power BI Service w/ the same details / credentials I get the below error. It is the first datasource that I am trying to add to the gateway. Does anyone have any ideas?
Thanks,
Ricardo
---
Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details
| Activity ID: | 9a5f1474-689f-449d-a1cf-1946f019b24e |
| Request ID: | 85114dab-5fc9-6d1a-7916-b46453617f93 |
| Cluster URI: | https://wabi-west-europe-redirect.analysis.windows.net |
| Status code: | 400 |
| Error Code: | DMTS_PublishDatasourceToClusterErrorCode |
| Time: | Wed Aug 15 2018 12:00:40 GMT+0700 (Indochina Time) |
| Version: | 13.0.6289.161 |
| Textyle: | Cannot connect to the server. |
| Underlying error code: | -2146232060 |
| Underlying error message: | 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: SQL Network Interfaces, error: 25 - Connection string is not valid) |
| DM_ErrorDetailNameCode_UnderlyingHResult: | -2146232060 |
| DM_ErrorDetailNameCode_UnderlyingNativeErrorCode: | 87 |
