Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
vijaycp2
Frequent Visitor

Error while connecting to dtaa source

We are getting following error message. The connection from PowerBI desktop works fine however we can't connect to SQL server database from Power BI 

 

vijaycp2_0-1736890545587.png

We have defined data source connection using settings - > manage connections and gateways 

 

vijaycp2_1-1736890617562.png

 

8 REPLIES 8
vijaycp2
Frequent Visitor

Look at the error message Do Sql server defines firewall rules for different executables? I can run queries from SSMS. 

Error message

Cannot connect to SQL Database. Please contact SQL server team for further support. Server: '10.110.36.69', Database: 'Viewpoint', User: 'vijay.sql'. Check the connection configuration is correct, and make sure the SQL Database firewall allows the Data Factory runtime to access. A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The target principal name is incorrect.), SqlErrorNumber=-2146893022,Class=20,State=0, The target principal name is incorrect Activity ID: 532c3901-2a0c-42c5-a676-ff236b3f5c2d

 

 

vijaycp2_0-1736965618935.png

 

Anonymous
Not applicable

Hi,lbendlin,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.


Hello, @vijaycp2 . I am glad to help you.
According to the screenshot of the error message you subsequently provided, the system suggests that the connection was successful but the name of the target subject is incorrect

Errors with incorrect target subject names are usually related to SSL certificate configuration.
I hope my suggestions below are helpful

1. Check the SSL certificate: make sure the subject name of the SSL certificate used by SQL Server matches the server name. If a self-signed certificate is used, make sure the client machine trusts the certificate.

URL:
Solved: provider: SSL provider, error 0:The certificate ch... - Microsoft Fabric Community
SSL Security Error with Data Source | Microsoft Power BI Blog | Microsoft Power BI
2. Try disabling SSL encryption: If SSL encryption is not required, you can disable SSL encryption by adding Encrypt=False to the connection string.

DataSource.Error: Microsoft SQL - Power BI - Microsoft Q&A

I can not rule out the possibility that your database “Viewpoint” is inaccessible to the account used for gateway authentication.
I noticed that the authentication method selected in your gateway connection is Basic mode.
So you are using a SQL Server login account to access the database.
Please check if your SQL Server account has access rights to Database: 'Viewpoint', and if not, please give it access rights.
You can try to create a new test database on the same computer IP (same SSMS) and give access rights to the database to the SQL Server login account you are using for the gateway connection, create a pbix report with the test database and configure the Service gateway connection to check if the same problem exists.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin
Super User
Super User

You need a gateway to access that on-prem database.

We do have gateway which connects to on-prem database. 

 

vijaycp2_0-1736899608952.png

 

Please show the connections section.

Worked with Microsoft technical support team and modified data gateway sqlsrvr.dll.config file. After dll.config changes started working. 

what did you change in that file?

vijaycp2_0-1736956497751.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.