Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Shivakumar03
New Member

Can Power Query copy and move files from one directory to another directory?

Would like to know if Power Query can copy files from one directory to another.

Ex: 

I have a file called abc.xlsx in 'C:\Users\Folder1\abc.xlsx' directory.

And i want to copy that file in another directory 'C:\Users\Folder2\'

 

So, after copying, that file is now in both directories.

C:\Users\Folder1\abc.xlsx

C:\Users\Folder2\abc.xlsx

 

Does Power Query have this facility to do this?

 

2 ACCEPTED SOLUTIONS
freginier
Solution Specialist
Solution Specialist

You can't directly from power query.

You need to use power automate or python linked to power query / power bi 

 

______________________________________________________

If you found this post helpful, please give Kudos C

View solution in original post

mussaenda
Super User
Super User

Hi @Shivakumar03 ,

 

Basically, power query is used to transform and load data.

It reads the files you connected.

 

For your desired function, better to use the power automate.

View solution in original post

2 REPLIES 2
mussaenda
Super User
Super User

Hi @Shivakumar03 ,

 

Basically, power query is used to transform and load data.

It reads the files you connected.

 

For your desired function, better to use the power automate.

freginier
Solution Specialist
Solution Specialist

You can't directly from power query.

You need to use power automate or python linked to power query / power bi 

 

______________________________________________________

If you found this post helpful, please give Kudos C

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors