Can I download files locally and run a Powershell ...

Anonymous · ‎10-10-2021

Hello

I want to combine several hundreds of csv files from a sharepoint and Power Query is very slow.

Is it possible to download the files quickly as with MS Edge and then run locally a Powershell script to combine them before loading them to Power Query?

Or do you have any other faster idea?

Thanks!

KNP · ‎10-13-2021

Do the files have a lot of rows?

How are you combining them in Power Query currently?

Share your code if you can.

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr