Forum Discussion
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?
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
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.
2 Replies
freginierSolution Sage
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
Community Champion
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.