I've built several queries using Power Query. It's now been several months & I just realized that I'm getting errors when I attempt to refresh the queries. I can't send the file because it contains confidential information. I'm attaching a Word document with screen shots of the error messages I'm receiving. I hope that provides you enough information to point me in the right direction to fix my errors. I seem to have learned enough from the class to be dangerous! I can create a basic query, but can't seem to figure out how to fix my mistakes when I find them the next month!
Hi Denise,
Using the automatic "Combine Data" button provided by power query is not very flexible, you should avoid that if there may be changes in your data.
Changing a folder path to a file path does not sound right, because these needs to be different operations performed: one is Folder.Files, the other is File.Content.
For other query errors, you should open the query, not the pop-up from the query panel. In query editor, you should check each step, there should also be a button "Go to error", this will take you directly to the step that failed.