Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
Note - this is solved. The issue was that I had to put IP,PORT rather than IP:PORT as on Power BI Desktop.
Note - this is solved. The issue was that I had to put IP,PORT rather than IP:PORT as on Power BI Desktop.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.