Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Power BI Dataset Refresh fail

Hello Power BI experts. I am facing an issue in one report. My project team has made the IP of SQL DB private so whenever I have to refresh the report, I should be on VPN via FortiClient. I have managed to configure the Gateway but this also becomes offline when I disconnect the VPN. Is there any way we may refresh the BI report with a private IP?

 

I am thinking of getting the Virtual Machine with a static VM and then requesting my client to wishlist this IP. If there is any better solution, please help. Thanks

Data Protection
Dataflow
General Comment
Interesting Links
Tutorial Requests
  • TomMartens's avatar
    TomMartens
    2 years ago

    Hey Anonymous ,

     

    if you have to use to a gateway, then you have to have a statip ip for the gateway, and this ip needs to be whitelisted. Probably Firewall rules are involved as well.

    Regards,

    Tom

8 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    2 years ago

    Hey Anonymous ,

     

    if you have to use to a gateway, then you have to have a statip ip for the gateway, and this ip needs to be whitelisted. Probably Firewall rules are involved as well.

    Regards,

    Tom

  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    Super User
    2 years ago

    Hi,

     

    Please try on-premises data gateway connection.You can contact your tenant admin he will help you on this.

     

    Thanks,

    Sai Teja 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi I have established the on premesis gateway. Kindly guide me about the tenant steps. I have the access of it 

      • SaiTejaTalasila's avatar
        SaiTejaTalasila
        Super User
        2 years ago

        Hi,

         

        What is the status of the connection is it showing online or offline?