An error occurred in the ‘Transform File’ query. Expression.Error: The key didn't match any rows in

[HasanK]

Dear Comunity,

I am learning and appling PowerBi, Power Query, PowePivot into my business life. This is my first post therfore it may look easy but I could not find proper solution... 

My Question is two part first part is the subject, actually I found the issue but I could not find solution;

- Our customer send every week their sales reports in excel or csv, I have just started to use PowerQuery to combine them but I realised different "table names" causes this error; some excel report sheet name are "prijmy_vydeje_skladem (005)", some prijmy_vydeje_skladem (009), etc.

When I change the name manually, The reports have the same sheet names are recognised by Power Query and not get error for that table...

How can I solve this issue first, there are 53 reports for each previous report.

I will be pleased, if you can you help.

Best regards,

Note: I use File/Folder as New Source in Power Query and locate the folder contains weekly reports

[lalilonso]

Hi,

I have the same issue, did you find a solution?

[HasanK]

Hi Lalilonso,

I put the solution video link in latest message, if it does not solve could you give an example?

[Greg_Deckler]

Hmm, not fun. Power Query is very touchy about its names. @ImkeF or @edhans may have suggestions.

[HasanK · Accepted solution]

Hello Greg,

Thank your for your advice. After many hour spent I found the soluiton and applied on my case with little modification, it isueful and easy. Here is the solution Combine Files With Inconsistent Columns In Power Query