Forum Discussion
Scraping data from PDF and save it
Hi All,
Very new to power Query and im hoping there is a solution to help me.
I have setup a quyery to import data from various PDF reports in various folders. A new PDF is regularly added and i would like power query to add this data, once a day or so. The issue is that the query takes an absolute age to run for the shear volume to pdf docs and the amount of query steps to remove the data and transform it.
- Is there a way to save the data and only work on new files
- Maybe archive the file once processed or change the name so it can be identified
Any ideas would be appreciated. An oportunity to learn!
Hi Neil_brown, give this a try, and if you encounter any issues, let me know.
Open PowerShell and run the command, making sure to change the source and destination to your own paths.
$sourceFolder = "C:\PDFs" $archiveFolder = "C:\Archive" $files = Get-ChildItem -Path $sourceFolder -Filter *.pdf foreach ($file in $files) { $destination = Join-Path -Path $archiveFolder -ChildPath $file.Name Move-Item -Path $file.FullName -Destination $destination }Did I answer your question? If so, please mark my post as the solution!
Your Kudos are much appreciated! Proud to be a Resolver IV !
3 Replies
Hi Neil_brown, give this a try, and if you encounter any issues, let me know.
Open PowerShell and run the command, making sure to change the source and destination to your own paths.
$sourceFolder = "C:\PDFs" $archiveFolder = "C:\Archive" $files = Get-ChildItem -Path $sourceFolder -Filter *.pdf foreach ($file in $files) { $destination = Join-Path -Path $archiveFolder -ChildPath $file.Name Move-Item -Path $file.FullName -Destination $destination }Did I answer your question? If so, please mark my post as the solution!
Your Kudos are much appreciated! Proud to be a Resolver IV !Hi Neil_brown
Did the solution ahadkarimi offered help you solve the problem, if it helps, please consider to accept it as a solution so that more user can refet to, or you can provide more information so that can help you solve the problem.
Best Regards!
Yolo Zhu
Hi ahadkarimi,
Thanks for the reply and appologies for not getting back to you earlier. I guess this solution takes the files from the specific folder and moves them to an archive location. Is there a way to automate this as part of the Power Bi scraping of data.
Regards
