October 6, 2015
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?
July 16, 2010
December 8, 2016
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.
July 16, 2010
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.
Most Users Ever Online: 57
Currently Online: Mynda Treacy
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas