error when loading a new table form SQL server: Expression.Error: The key didn't match any rows

[vika160]

Hi there,

I am looking for help.

Created 2 new views ( with very close fields, at least ID fields are the same and from the same table) and first view  loaded successfully and the other was given me this error:

Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Schema=dbo
Item=V_PBI_BUS_PAYMENT
Table=[Table]

FInally it loaded but I cannot transform data as an error is still in Query Editor.

I have check the commnuty and google and I saw this error is mostly with Excel files. 

Any help would be appreciated.

Thanks a lot.

[parry2k · Accepted solution]

@vika160 well then you are good to go, remove any step after this. Seems like this table was added after original power bi file was created and navigation step was not able to find the table and was getting error, once you click the refresh at source, it updated the list of table and that fixed the issue.

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@vika160 click on the Table in the data column and see if you get the preview. 

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[vika160]

yes, i can see data properly

[parry2k]

@vika160 if you go to the source step, and click refresh, do you see V_PBI_BUS_PAYMENT table?

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[vika160]

Yes, I see it

[parry2k]

@vika160 seems like some of the columns are removed or column names are changed, column names are case sensitive. Can you paste the code from the advanced editor?

[vika160]

hi @parry2k 

This is a brand new query as I mentioned in a post.

Here is code:

let
Source = Sql.Database("****", "****_prod****"),
dbo_V_PBI_BUS_PAYMENT = Source{[Schema="dbo",Item="V_PBI_BUS_PAYMENT"]}[Data]
in
dbo_V_PBI_BUS_PAYMENT