API provider requires IP Whitelisting

[Anonymous]

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?

[Anonymous]

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 · Accepted solution]

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.