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

[Shivakumar03]

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?

[freginier · Accepted solution]

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

[mussaenda · Accepted solution]

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 · Accepted solution]

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