cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Lab 7 Exercise 1 - The target principal name is incorrect. Cannot generate SSPI context.

powerbi.jpg

 

Hi, I encounter this problem while doing lab 7 exercise 1 in EDX Power BI course.

I have no idea how to resolve this.

Help 😞

 

1 REPLY 1
New Member

I had encountered the same error "Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context." when trying to refresh data on PBI Desktop. 

 

Before the error showed up, PBI Desktop could connect to the SQL DB and refresh data for the past 18 months. The error msg just showed up one day.

 

The SQL DB's Windows server password had expired. However, that password remains unchanged as per company policy. 

 

The following steps help to resolve my issue:

  1. Go to Power Query Editor window
  2. Click on "Data Source Settings" from the ribbon menu
  3. In the "Data Source Settings" window, select the affected data source and click on "Edit Permissions"
  4. In the "Edit Permissions" window, under "Credentials", click on "Edit".
  5. Select "Database" and fill up the SQL credentials.
  6. Save and refresh all data.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.