Stock Prices: Multiple API Keys in Desktop but only a Single Key in Power BI Service... why?

[Anonymous]

We have built a Power BI report that pulls stock prices of mutiple companies for a comparison. We'd like those prices to refresh multiple times a day. Most free stock price API services restrict how many times you can hit the service. Because of this we have unique API keys for each stock price we are refreshing. This works fine in Power BI Desktop because each API string is refreshed individually with its unique API key.

However, in the Power BI Service when we try to refresh ALL stock prices for multiple companies we are getting an errors because Power BI service is using a single API key and not the multiple keys that exist in the queries for each stock.

So two questions:

1. Does anyone know why Power BI Service won't use the individual API keys that the Desktop queries have and is only using a single API key to connect to a stock website service?
2. Is there a better way to pull multiple company stock prices and have them automatically refresh in the Power BI Service?

Thanks!

Note: We are using and sharing a Power BI Report in the service and not a Dashboard for design/UI reasons.

[v-jiascu-msft]

Hi @Anonymous,

Would you mind telling me if you connected to a web service (single domain) with many API keys? 

Best Regards,

Dale

[Anonymous]

Hi Dale. Thanks for getting back to me. The webservice limits us to 1 call per minute per API key... we setup multiple API keys which we have in the Power BI desktop.

Here's why: what we've found is when we try to refresh all the API calls from the Power BI service instead of using the individual keys from the Power BI Desktop file it is using a single API key and then failing because it is attempting to refresh multiple stock prices at a single time.

We are only talking about 20 or so company stock prices so it's not a huge data volume... we are just trying to enable the refresh process to work from the Power BI Service by using the multiple API's in the queries.

Thanks!

Russ