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

[shiling-chen]

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 😞

[ooodrey7]

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.