Excel Forum

Get data from folder does not show files

Raja Rangar

Active Member

Members

Forum Posts: 5

Member Since:
January 7, 2021

Offline

June 12, 2021 - 12:49 am

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

Anders Sehlstedt

Eskilstuna, Sweden

VIP

Members

Trusted Members

Forum Posts: 917

Member Since:
December 7, 2016

Offline

June 12, 2021 - 2:15 am

Hello,

Have you seen this article about get files from folder?

https://www.myonlinetraininghu.....m-a-folder

Br,
Anders

Raja Rangar

Active Member

Members

Forum Posts: 5

Member Since:
January 7, 2021

Offline

June 14, 2021 - 11:28 pm

Hi Anders,

Thanks for looking into this.

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

Regards

Catalin Bombea

Iasi, Romania

Member

Dashboards

Power Query

Power Pivot

Xtreme Pivot Tables

Excel for Decision Making

Excel for Finance

Excel Analysis Toolpak

Power BI

Excel

Word

Outlook

Excel Expert

Excel Customer Service

PowerPoint

Forum Posts: 1939

Member Since:
November 8, 2013

Offline

June 14, 2021 - 11:48 pm

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?

Raja Rangar

Active Member

Members

Forum Posts: 5

Member Since:
January 7, 2021

Offline

June 15, 2021 - 10:52 pm

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

Attachments

Screen-shot.PNG (33 KB)

Catalin Bombea

Iasi, Romania

Member

Forum Posts: 1939

Member Since:
November 8, 2013

Offline

June 15, 2021 - 11:02 pm

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.

Raja Rangar

Active Member

Members

Forum Posts: 5

Member Since:
January 7, 2021

Offline

June 18, 2021 - 11:40 pm

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

Attachments

Empty-Folder.PNG (130 KB)

Catalin Bombea

Iasi, Romania

Member

Forum Posts: 1939

Member Since:
November 8, 2013

Offline

June 18, 2021 - 11:59 pm

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.

Raja Rangar

Active Member

Members

Forum Posts: 5

Member Since:
January 7, 2021

Offline

June 19, 2021 - 6:34 am

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

Thanks and God bless you.