Forum Discussion
Connect to a network folder behind VPN
Hi Grzegorz,
This type of thing is what On-Prem Gateways are for.
You should set up a gateway machine on-premises, plugged into your office network, which you can then store credentials on to access the local network and many other data sources.
You set up your local network path as a new data source on the gateway (from within the PBI Service) then, when you publish your report to the PBI Service, you adjust the dataset settings in the Service to use your gateway data source to connect. The gateway will then use the stored credentials to access your network, grab the data, transform it, then send the new dataset to the PBI Service to refresh your report.
It's a fairly large (but not difficult) topic, so I recommend checking out the MS Docs on the subject:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
Pete
Hi Grzegorz,
This type of thing is what On-Prem Gateways are for.
You should set up a gateway machine on-premises, plugged into your office network, which you can then store credentials on to access the local network and many other data sources.
You set up your local network path as a new data source on the gateway (from within the PBI Service) then, when you publish your report to the PBI Service, you adjust the dataset settings in the Service to use your gateway data source to connect. The gateway will then use the stored credentials to access your network, grab the data, transform it, then send the new dataset to the PBI Service to refresh your report.
It's a fairly large (but not difficult) topic, so I recommend checking out the MS Docs on the subject:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem
Pete
Hi Pete!
Thanks for replay. I've consulted this issue with other people from my organization and yes - that's the way to handle that situation. Thank you!