Error: the key didn't match any rows in the table - but refresh preview works!

[Jannas91Berlin]

Hello, I keep getting the error "the key didn't match any rows in the table" when I want to refresh my reports/tables. However, in the editor when i refresh the preview, i can see the changes without any issue but as soon as I load, the error comes back. what can i do? I get some data from excel tables and other from a sharepoint folder. Thanks so much, I've been struggling with this for days!

[Jannas91Berlin · Accepted solution]

I finally found the problem, it was an old import from a sharepoint folder that a colleague deleted! Thanks anyway!

[Omid_Motamedise]

Can you provide your M code here?

[Jannas91Berlin]

It's in German, does it still help?

[Jannas91Berlin]

It's in German, would that still help?