My Data is not combing. Any suggestions about what to check?

[stjimi]

I have looked at column headers, file types, formats. 

I can't work out why some files combine and others do not. 

I get this message. 

Any ideas? 

[v-stephen-msft · Accepted solution]

Hi @stjimi ,

I found this solution works for some people, hope it will help you too:

it works, i was issue of data format there shoudnt be difference between excel and power bi (query editor), i setup data format for every column  (whre should be text i setup in power bi query  editor "text", where should bu number i setup "number") and its helps

Solved: Expression.Error: The key didn't match any rows in... - Microsoft Power BI Community

Also in the following blog, the author introduced two ways to fix this error:

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

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[watkinnc]

The issue is probably that your Transform Sample File query is pointing to a file that is not actually the Sample File. I would check the Source in the Transform Sample File, and make sure that it is pointing to the Sample File. Also, make sure that you don't expand the sample file!

--Nate