Error message the key didnt match any rows in the table

[lisaott]

Hello everyone,

i want to load data from a excel worksheet into my report and always get the following error:

Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Item=test
Kind=Sheet
Table=[Table]

I already have data from another excel file in my report and it works well.

The files are in the same folder. 

When moving one file to another folder, i don't get the error.

[selimovd · Accepted solution]

Hey @lisaott ,

this error message usually comes when the sheet you're looking for doesn't exist in the current Excel file.

Make sure, that the sheets are named similar and exist in every Excel file.

Chris Webb wrote a more detailed article about that a while ago:

https://blog.crossjoin.co.uk/2020/04/06/understanding-the-the-key-didnt-match-any-rows-in-the-table-...

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
Connect with me: LinkedIn