Refresh form Data source in secure server

[Elmo22]

Hi All 

Requirment is to publish and configure auto refresh a report that read data from multiple DBs, some of which are in secure server that can not be access except from within local network or through VPN

what are the steps?

Thank you in advance 

[v-saisrao-msft]

Hi @Elmo22,

We haven’t heard back from you regarding Refresh form Data source in secure server. If it has been resolved, please mark the helpful response as the solution to assist others. If you still need support, let us know.

Thank you.

[v-saisrao-msft]

Hi @Elmo22,
checking in to see if your issue has been resolved. If the response provided was helpful, kindly mark it as the solution so that others with the same issue can benefit.
Please let us know if you still need assistance.
Thank you.

[v-saisrao-msft]

Hi @Elmo22,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-saisrao-msft · Accepted solution]

Hi @Elmo22,

Thank you for reaching out to the Microsoft Fabric Forum Community.

As suggested by @BhavinVyas3003, use the On-premises data gateway to connect your secure servers to the Power BI Service. Use the Standard (Enterprise) gateway rather than the personal gateway, as the standard version.
As it supports multiple data sources and is used by organizations.
Also, check and configure valid credentials with appropriate access to the database.

Below is the Microsoft link for your reference:
Install an on-premises data gateway | Microsoft Learn.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.

[BhavinVyas3003]

Hi @Elmo22 ,

For Power BI Service accessing secure servers, deploy an On-Premises Data Gateway within your local network or VPN to securely connect to your databases, then configure your datasets in the Power BI Service to use this gateway for scheduled refreshes. Ensure the gateway is always online with correct credentials, and set up scheduled refresh in the Power BI Service to enable automatic updates of your reports using data from those secure sources.