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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
neil_floyd
Regular Visitor

Can't connect to MS SQL Server through VPN

Hi all,

In Power BI Desktop I am trying to connect to a MS SQL Server, through a VPN, but I keep getting an error: 
"Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context"

I am able to sucessfully connect to the database from Azure Data Studio (after connecting to the VPN), using the following configuration:

neil_floyd_1-1700924952921.png


In Power BI I just type the server IP in the Server input dialog:

neil_floyd_2-1700925200297.png

 

And get the error: "Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context"

I think it might be something related to the "encrypt: False" and  "trustServerCertificate: False" that I am able to set in Azuere Data Studio, but not in Power BI.

I don`t have much technical knowlodge regarding this subject, so I would apprecite any help!

1 REPLY 1
Fowmy
Super User
Super User

@neil_floyd 

Under Data "Data Source Settings", click on the connecton and check the Privacy Level, switch it and test:

Fowmy_0-1700933724793.png

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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