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

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) 

    • SaiTejaTalasila's avatar
      SaiTejaTalasila
      Super User
      2 years ago

      Hi,

       

      I'm not sure but I have a doubt.Why can't you make VPN activate on the on-premises data gateway VM? Are they on different networks?.As per my knowledge there will be a VM for every gateway in the cloud where we add TNS entries or ODBC connections for on-premises data gateway connections.