Forum Discussion

gregboothdelt's avatar
4 years ago
Solved

Fixed IP address

We are developing power bi reports that connect to a Amazon Redshift instance. This has been setup so that it only accepts connections from a fixed ip address (of traffic  from our network)

When we deploy reports to the power bi service, they cannot connect - as the service has a different ip address - and this is presumably not fixed or has a large range of addresses.

Has anyone found a way of making data coming from the power bi service have a fixed ip address ?  Maybe routing traffic through something like an instance of Azure API Management (which can have a fixed IP address)  

4 Replies

    • gregboothdelt's avatar
      gregboothdelt
      Helper I

      Microsoft support were able to give us the list of Azure IP's for Power BI service for our region (UK south).

      This was still too many - and we are going to try to route the traffic via our on prem gateway

    • malafaiabarbara's avatar
      malafaiabarbara
      Frequent Visitor

      You could create a VM with static IP, than install a Power BI on-premises gateway in the VM.

      Create a connection in Power BI online using that on-premises gateway.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi gregboothdelt ,

     

    Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!

     

    Hope it helps,


    Community Support Team _ Caitlyn Yan


    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.