Forum

Get data from folde...
 
Notifications
Clear all

Get data from folder does not show files

9 Posts
3 Users
0 Reactions
2,051 Views
(@raja)
Posts: 5
Active Member
Topic starter
 

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

 
Posted : 12/06/2021 10:49 am
Anders Sehlstedt
(@sehlsan)
Posts: 972
Prominent Member
 

Hello,

Have you seen this article about get files from folder?

https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder

Br,
Anders

 
Posted : 12/06/2021 12:15 pm
(@raja)
Posts: 5
Active Member
Topic starter
 

Hi Anders,

Thanks for looking into this. 

Yes, I read that article and could not find solution to my issue. 

Regards

 
Posted : 15/06/2021 9:28 am
(@catalinb)
Posts: 1937
Member Admin
 

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?

 
Posted : 15/06/2021 9:48 am
(@raja)
Posts: 5
Active Member
Topic starter
 

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.

 

Screen-shot.PNG

Thanks

 
Posted : 16/06/2021 8:52 am
(@catalinb)
Posts: 1937
Member Admin
 

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.

 
Posted : 16/06/2021 9:02 am
(@raja)
Posts: 5
Active Member
Topic starter
 

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

Empty-Folder.PNG

 
Posted : 19/06/2021 9:40 am
(@catalinb)
Posts: 1937
Member Admin
 

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.

 
Posted : 19/06/2021 9:59 am
(@raja)
Posts: 5
Active Member
Topic starter
 

That worked. Thanks a lot. I really appreciate your wonderful help.

Thanks and God bless you.

 
Posted : 19/06/2021 4:34 pm
Share: