• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Query error when combining files

I have 5 files, each with multiple tabs. I am trying to combine the "Project" tab from each file. I can't attach the files (confidential data). The headers in all files are in the same order and spelled the same way. All have the same casing. What could be causing this error?
 

Attachments

  • Power Query Error Message.png
    Power Query Error Message.png
    2.7 KB · Views: 2
Last edited:
Please share your m-code. Maybe your headers look alike. Trailing spaces, lower uppercase is easily overlooked. With the code we can offer guidance to tweak the m-code and so work around the issue.
 
Back
Top