Power Query - Query Parameter for Dynamic Folder Location

canefan17

New Member
Joined
Jan 27, 2015
Messages
14
Excelisfun has a video on this topic.

https://www.youtube.com/watch?v=0NX-GctfZuU

I performed the steps and had my query set up. Then I added next month's sales file to the import folder and hit data refresh. The query only pulled in 1 of the files (oddly enough, the most recently added).

Why isn't it pulling everything in the folder like it normally does?

Also, I tried clicking on the double down arrows to expend the data in the binary column, and it gave me the following error: "We cannot find a table named table2."
 

Forum statistics

Threads
1,085,419
Messages
5,383,552
Members
401,836
Latest member
Bweston07

Some videos you may like

This Week's Hot Topics

Top