question

Swapnilkumar-8722 avatar image
0 Votes"
Swapnilkumar-8722 asked PRADEEPCHEEKATLA-MSFT commented

Getting "Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context." error when trying to connect Synapse Studio to Power BI

Getting "Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context." error when trying to connect Synapse Studio to Power BI when running the downloaded .pbids file according to the steps in this article :
https://docs.microsoft.com/en-us/azure/synapse-analytics/get-started-visualize-power-bi

I am ale to connect to the sql server, but on selecting the database in the navigator on Power BI, I see the following error:

133147-image.png


azure-synapse-analytics
image.png (45.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @Swapnilkumar-8722,

Thanks for the question and using MS Q&A platform.

As we are unable to repro this issue and able to successfully able to connect the Azure Synapse Analytics with Power BI desktop.

133611-image.png

As per the similar issue, discussed on the Power BI community forum: Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context.

You may follow the below steps help to resolve the issue:

  • Click on File and select Option and settings

  • Click on Data Source Settings

  • In the "Data Source Settings" window, select the affected data source and click on "Edit Permissions"

  • In the "Edit Permissions" window, under "Credentials", click on "Edit".

  • Select "Database" and fill up the SQL credentials.

  • Save and refresh all data.

In case if the above solution does not works for you, I would request you to open a new issue on Power BI community Forum.

Hope this will help. Please let us know if any further queries.


  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification

  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators


image.png (147.9 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @Swapnilkumar-8722,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·
Swapnilkumar-8722 avatar image Swapnilkumar-8722 PRADEEPCHEEKATLA-MSFT ·

Hey @PRADEEPCHEEKATLA-MSFT !

Thank you for your quick response. I tried out the solution mentioned above and it worked out perfectly fine. Thanks !

1 Vote 1 ·

Hello @Swapnilkumar-8722,

Glad to hear that your issue is resolved. Please do continue to use MS Q&A platform for any questions related to Azure.

0 Votes 0 ·