Hi,
I am new to this forum so please ignore if I make any mistake. I am an excel user and have recently started using Power Query in excel in Office365.
When I try to get data from a folder on my computer, I don't see Folder and folder path of Power Query. Instead I see the regular Windows path or explorer path. Any help would be much appreciated.
Thanks
Hello,
Have you seen this article about get files from folder?
https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder
Br,
Anders
Hi Anders,
Thanks for looking into this.
Yes, I read that article and could not find solution to my issue.
Regards
What do you actually see? "folder path of Power Query" does not mean anything to me.
Can you upload a screenshot to see what you mean?
Hi,
This is what I see when I select "Get data, from folder". I don't see folder option and if I go through following path, I don't see any file in the folder. Folder does not show any file, it's empty.
Thanks
Ok, so you use Get Data>From File>From Folder, the folder browser dialog is displayed.
Have you tried to select a folder from that dialog and click the Open button from that window?
The power query process starts after you select a folder.
Hi,
Yes, I tried that, but folder does not show files that I have saved there. Please see the image of empty folder that I get. Thanks
You are browsing for a FOLDER, not for a file, so you will see folders only.
Once you have selected the desired folder, just press the Open button, should not be hard.
That worked. Thanks a lot. I really appreciate your wonderful help.
Thanks and God bless you.