
(2) I think you will need to Install the on-premises gateway to be able to save files to your local hard drive or network folder:
The installation and configuration is reasonably well explained here: Install an on-premises data gateway | Microsoft Learn
I've also attached a PDF which I used previously to install and configure the gateway.