Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

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 ...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

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

 

Best Regards,

Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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