Log In
Register
Home
Active Member
January 7, 2021
Offline
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
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Have you seen this article about get files from folder?
https://www.myonlinetraininghu.....m-a-folder
Br,
Anders
Active Member
January 7, 2021
Offline
Hi Anders,
Thanks for looking into this.
Yes, I read that article and could not find solution to my issue.
Regards
November 8, 2013
Offline
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?
Active Member
January 7, 2021
Offline
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
November 8, 2013
Offline
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.
Active Member
January 7, 2021
Offline
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
1 Guest(s)
