Forum

Is it possible to g...
 
Notifications
Clear all

Is it possible to get data from folder and keep it updated

5 Posts
2 Users
0 Reactions
74 Views
(@mgbasheerh)
Posts: 13
Eminent Member
Topic starter
 

Hi,

I have several .xlsx files stored in a certain path in my computer.

These files have a fixed format, but there are new files will be added later on weekly.

So I do the power query work for each file separately and then combine queries from all files later on.

I saw your video when getting files from a sharepoint folder.

Can I do so with regular .xlsx files from a regular folder?

So the files being added I want it to be added to the work and just refresh the data to get it into results.

Thanks

 
Posted : 20/12/2020 7:25 am
(@mynda)
Posts: 4761
Member Admin
 

Hi MG,

Yes, you can do this with Excel files saved on your PC or a network server in the same way. i.e. Get Files > From Folder > browser to your folder path.

Mynda

 
Posted : 21/12/2020 12:06 am
(@mgbasheerh)
Posts: 13
Eminent Member
Topic starter
 

Thanks a lot and much appreciated.

By the way how to add my picture to my profile?

 
Posted : 21/12/2020 1:19 am
(@mynda)
Posts: 4761
Member Admin
 

You're welcome!

You can add a photo by clicking on the 'member' icon above your name. Then edit profile > edit avatar.

Mynda

 
Posted : 21/12/2020 7:08 am
(@mgbasheerh)
Posts: 13
Eminent Member
Topic starter
 

You can add a photo by clicking on the 'member' icon above your name. Then edit profile > edit avatar.

I did tried but it is not clickable unless I got it wrong.

Did not you mean to click on the icon itself? Avatar

It is not clickable.

 
Posted : 21/12/2020 8:10 am
Share: