cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.