Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

API provider requires IP Whitelisting

Hi

 

I need to pull some data from an API. The API provider only accepts anonymous logon with an API key.

I can easily refresh the data in PBI desktop, but it fails when I want to use the cloud.

 

The reason, I guess, is due to the API provider requiring that All IP Adresses requesting data through the API, must be whitelisted in their backend. 

 

So... The $1000 question is; How do I whitelist the IP adress of the PBI Cluster URL? Or is there anyone who have expirienced something similar and knows of a workaround?

 

Here's a screenshot. As you can see, it's a simple web query where the API key is applied in the URL.. 

 

 

 

 

 

Any ideas?

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Thanks.. 

     

    However, I ended up with a workaround, using Power Query and a job scheduler to get the result from the API provider on a daily basis nad then using that result as input to power bi. 

     

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Anonymous,

     

    About power bi service refresh, you can take a look at below article to know more about them:

    Power BI Security

     

    Based on document, I don't think it will use the static ip. So it is hard to achieve your requirement. In addition, you can contact to power bi team for further support.

     

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Thanks.. 

       

      However, I ended up with a workaround, using Power Query and a job scheduler to get the result from the API provider on a daily basis nad then using that result as input to power bi.