Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by watching the DP-600 session on-demand now through April 28th.
Learn moreJoin the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
Hi,
I was trying to connect my Power BI with SQL Server, I was getting the below error.
Error Message:
Unable to Connect
We encountered an error while trying to connect
Details: "Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context."
Please help me #powerbicommunity.
Thanks in Advance.
Vikranth
Solved! Go to Solution.
Yeah, that's very strange i know.
Try to go to File -> Options & Settings -> Data Source settings. There you can change the auth mode.
- Can you connect to the SQL Server via SSMS?
- Did you use Windows auth or SQL auth?
Yes, I'm able to connect via SSMS using SQL Authentication.
And you are sure that you also used SQL Auth in PowerBI? Because i think with SQL Auth there would bei no SSPI context.
There's no option for Authentication in Power Bi while connecting to SQL Server. After filling in the server and database details in power bi and OK, I got the error mentioned above. It is not navigating me to the Authentication window.
Yeah, that's very strange i know.
Try to go to File -> Options & Settings -> Data Source settings. There you can change the auth mode.
wonderful! please mark it as solution (my answer) 🙂
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 41 | |
| 37 | |
| 34 | |
| 21 | |
| 16 |
| User | Count |
|---|---|
| 64 | |
| 58 | |
| 31 | |
| 25 | |
| 25 |