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 through VPN

 

what are the steps?

 

Thank you in advance 

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.

5 Replies

  • 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.

     

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    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.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    1 year ago

    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's avatar
    v-saisrao-msft
    Community Support
    1 year ago

    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's avatar
    v-saisrao-msft
    Community Support
    1 year ago

    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.