Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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
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.
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.
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