topic Re: Issue Connecting Fabric Warehouse to Excel - SSPI Context Error in Data Warehouse

Issue Connecting Fabric Warehouse to Excel - SSPI Context Error

goldenarm253 — Thu, 07 Nov 2024 12:46:52 GMT

I'm experiencing an issue linking my Fabric warehouse to Excel. It seems to be specific to Excel, as Azure Data Studio connects without any problems.

Here's the error message I received:

DataSource.Error: Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context.
Details:
DataSourceKind=SQL
DataSourcePath=datawarehouse.fabric.microsoft.com;SomeName
Message=The target principal name is incorrect. Cannot generate SSPI context.
ErrorCode=-2146232060
Number=0
Class=11
State=0

Has anyone encountered this before, or can offer guidance on troubleshooting this error?

Thanks in advance!!!

Re: Issue Connecting Fabric Warehouse to Excel - SSPI Context Error

lbendlin — Thu, 07 Nov 2024 13:48:21 GMT

you seem to be trying to connect with your Windows credentials. Try OAuth2 instead.

Re: Issue Connecting Fabric Warehouse to Excel - SSPI Context Error

AndyDDC — Thu, 07 Nov 2024 13:52:01 GMT

Hi goldenarm253 how are you trying to connect to the Fabric Warehouse? E.G Get Data?

Re: Issue Connecting Fabric Warehouse to Excel - SSPI Context Error

goldenarm253 — Thu, 07 Nov 2024 14:06:51 GMT

Correct, I use Get Data --> SQL Server. I pasted server name from Fabric. Then the error pops up.

Re: Issue Connecting Fabric Warehouse to Excel - SSPI Context Error

lbendlin — Thu, 07 Nov 2024 14:12:19 GMT

Clear the data source permissions, then reauthenticate with OAuth2 (Microsoft account). Do not use the Windows option.

Re: Issue Connecting Fabric Warehouse to Excel - SSPI Context Error

goldenarm253 — Thu, 07 Nov 2024 17:07:15 GMT

Worked!

Thanks