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

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?

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