Forum Discussion
New data file failing in query import
I am self taught and do not have a coding background. I generally get Power BI, but I have a hard time wrapping my head around Power Query. I have a folder where I drop in monthly data. The last ...
lbendlin
Super User
Super UserPower Query is case sensitive. Make sure all the sheets have exactly the same name across all files. (also look for trailing spaces)
Note: While the "Combine Binaries" feature is ok for beginners, at some point you will want to clean that up and write your own multi-file ingestor. I have a blog entry for that if interested.
Thanks - feel free to post your blog entry too.
- lbendlin