Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Thanks!
Note: We are using and sharing a Power BI Report in the service and not a Dashboard for design/UI reasons.
Hi @Anonymous,
Would you mind telling me if you connected to a web service (single domain) with many API keys?
Best Regards,
Dale
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.