Expression.Error: The key didn't match any rows in the table

[SteveS1]

I need assistance.

I get the above shown expression error.

I am in the desktop.  I  am connecting to an Azure SQL database.  It has 20 tables. I have previously direct connected to 18 of the 20.  Now i open a brand new model, and i choose to connect to previous data source.  I see all 20 tables.  I choose the 19th table.  As soon as i 'check the box' (selecting the table), the above error (The key didn't match any rows in the table) shows up in the Navigator box. 

The table has a primary key.  It also has a foreign key to another table.

This is my first post.  Have i missed providing any important information to solving this issue?

[HoustonMike]

I received this error as well, but the refresh didn't clear the message. However, when I deleted the 'Navigation' step and then refreshed, the error successfully cleared. In your post here, you mentioned a change in a subsequent release to auto refresh the local cache. Was that implemented?

[SteveS1]

That was easy!  Thank you!  I am just beginning my PowerBI steps.  Now, i am off again into the journey.

[fbrossard]

Hi @SteveS1

When you're facing this kind of issue try this trick :

1. Open the Queyr Edito by selecting "Edit Queries"
2. Select one of the queries having the issue (one of those which shoul have a warning sign)
3. On the applied steps, select the source step.
4. And click on Refresh Preview button available in the ribbon