Forum Discussion

Elmo22's avatar
Elmo22
Frequent Visitor
1 year ago
Solved

Refresh form Data source in secure server

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 t...
Need Help
  • v-saisrao-msft's avatar
    v-saisrao-msft
    1 year ago

    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's avatar
BhavinVyas3003
Super User
1 year ago

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.