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 @d_gosbell ,
I'm currently trying to connect Power BI Desktop (for Report Server) with SQL Server to connect to a data source.
IT has provided me the Server details, SQL Statement, and Connection String to input here in Power BI.
Once I input the required details here (Server, database, also added a SQL Statement in advanced options).
Next, I input the required database user and password.
The IT dept has connected the ports to ensure connection is established to the SQL Server. However, after that this error comes up. Kindly assist on how to fix this error.
Thanks in advance! Appreciate the support.
Hi,
Are you able to connect through SQL Server Management Studio (SSMS) with the same information? Added the reference link for your scenario to check - https://stackoverflow.com/questions/3270199/a-connection-was-successfully-established-with-the-serve...
Thanks
Hari
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.
User | Count |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
3 | |
3 |