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

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    It is online but I should be on VPN to access the DB due to private IP. 

    • SaiTejaTalasila's avatar
      SaiTejaTalasila
      Super User
      2 years ago

      Hi,

       

      Are you running vpn app on your gateway VM?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        No VPN is running from FortiClient. Challenge IS Power BI Service will also only refresh the reports once VPN is active on desktop. Any solution to this? other than I have to go for separate VM and then I request to Network team to wishlist the IP of VM (having static VM)