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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors