Expression.Error when combining multiple files with the same format

[kimlien3006]

Hi everyone, 

I've tried several times to fix the Expression. Error and it was not successful. Maybe you can give me some advices how to solve it. I have around more than 20 files (monthly reports from 07/2018 to 08/2020) with the same format and inserted in a shared drive. I connected all files to Power BI and combined files. At the end I should have one query with all data. However, there is an Expression. Error. The name of the files has a format A_ YYYYMM_(the time it was downloaded from the system). 

Looking forward to hearing from you! 

Thank so much!

[kimlien3006 · Accepted solution]

Hi @Jimmy801 

I solved the problem by myself. I just changed the name of the tab in each file so that they have the same name for the tab. But thanks anyways! 

[Jimmy801]

Hello @kimlien3006 

probably they don't have the same structure. I would need the exact Expression.Error and your custom function to understand what is causing this, because it's your custom function that returns the error.

BR

Jimmy

[kimlien3006]

Hi @Jimmy801 

Here is the custom function = Table.AddColumn(#"Filtered Hidden Files1", "Transform File (2)", each #"Transform File (2)"([Content]))

And the error, please see the screenshot. 

Thanks!

[Jimmy801 · Accepted solution]

Hello @kimlien3006 

try to check out this link 

Please check out also if for this files, where an error is created, if the sheet name is really the same

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[kimlien3006 · Accepted solution]

Hi @Jimmy801 

I solved the problem by myself. I just changed the name of the tab in each file so that they have the same name for the tab. But thanks anyways!