In the latest Power Query update, they added the above topic. I am trying to do a Query from a folder with three text files and three columns in each file. Before, I used to click on the double arrow icon in the Content (Binary) columns, and I would get the three columns, but now all three columns are combined into a single column and I am getting many queries.
So, I split the columns and then loaded the data into a table, I got an individual sheet from all of the queries.
It was so much easier before. Is there anything that I can do?
Thank you!
Hi David,
You can choose a different delimiter in the CSV dialog box that appears after you click the double down arrow to expand the binary. Also make sure the file origin selected is correct.
Mynda
I am having trouble with this new process as well. When I try to create a query "from Folder" my data is truncated at about 434 records when there should be approx 2500 records. I reviewed the updated instructions, but am having trouble still. My files are all spreadsheets, but only the first file seems to be converted to a table, and then the rest show an error. I haven't had to convert my sheets in each file to a table to use it in the past. If there is an update to PowerQuery in Excel 2016 I don't know where to find it.
Hi Cheryl,
There is an updated video for tutorial 2.05 From Folder. Please review the tutorial again. The old tutorial is also on that lesson page so you can compare what you see in your version of Excel and figure out which process to follow.
If you're still having problems please raise a new thread in the forum but this time post it in the Course Members - Power Query forum. This thread is in the non-member forum so if I refer to tutorials it can be confusing for those who aren't course members.
Thanks,
Mynda
