Forum Discussion
Expression.Error when combining multiple files with the same format
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!
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!
Hello Anonymous
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
4 Replies
Hello Anonymous
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
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!
Hello Anonymous
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