API costs

[jamiec8879]

We are hoping to display some of our dataverse information via api in a custom developed portal. The portal will be for our 100 or so customers to access their unique account related data on a daily basis. I've been a bit confused on what the charges are for making API calls are above the standard user licenses listed on https://powerapps.microsoft.com/en-us/pricing/.

Can anyone offer us some guidance on how API call relating charges would be applied so we can forecast costs?

In addition, does anyone know if there any API call limits we should be aware of that could limit our portals ability to retrieve data? in some places i see 6000/min and others 40,000 per day, but i'm unclear what is applicable and what happens if we hit the limit.

Thank you!

[rampprakash]

HI @jamiec8879 

Please find the attachment for your reference.

Link for your reference : https://docs.microsoft.com/en-us/power-apps/developer/data-platform/api-limits

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

[jamiec8879]

Thank you for the reply!

Is that limit included with the per user subscription plan (ie $20usd / month)? and do you know if there are any additional costs of the limit is hit, or do we just have to wait?

thanks!

[eleung83]

MS don't put a hard stop when you hit the limits, and they've recently released the ability (or were discussing the ability about providing reports) where you can monitor api usage.

The 40000 you're seeing is the maximum number of api hits per real user per day to the underlying dataverse database hosting your portal/d365 apps/power automate flows etc. 

The 6000 you're referring to could be either

1. the API protection limits to minimize performance degradation on your dataverse database (it's per user and per 5 minute sliding expiration)

2. The max number of api hits per real user per day if you're using PAYG plans or a couple of other non power platform licenses

Reference: https://docs.microsoft.com/en-us/power-platform/admin/api-request-limits-allocations

fyi the license limits are separate from the API protection limits (the api protection limits are just for safeguarding the performance of your dataverse environments)

Also, from the article above, MS won't just stop your dataverse environments if you hit these limits, but they would probably keep reminding you to buy addition capacity add-ons or perhaps restructure your api calls to take advantage of the non-licensed user request limits. I'm guessing as a last resort they would throttle your dataverse environments until you paid for more capacity or bought a combination of different licenses per user

[jamiec8879]

Thank you all, very appreciated. What we can't figure out is how the calls are calculated. For a 1 month filter, including connectors of course, we have 45M calls which is WAY above the limits mentioned above. Does anyone know how API calls are calculated, because we have complete no where near that number of calls unless it is registering a call per row of data or some other multiplier. 

https://share.getcloudapp.com/v1uQ6P8n


Thanks all

[eleung83]

From a licensing perspective, 1 month is irrelevant, all that matters is how many API hits are performed on a daily basis and by whom (e.g. real user/app registration/power automate flow) and the licenses that you have assigned to these individual components (app registration users use a different pool of API hits)

Any action (CRUD action) against your dataverse database is considered an API request (and this is per action e.g. creating 100 records = 100 API requests but retrieving 100 records in one query = 1 API request), but there's a few internal system operations and metadata requests that are not counted towards these API limits.

You should try out the preview reports listed in the link I posted previously as it gives you a breakdown of both non-licensed/non-interactive user apis requests per day over the last 30 days, as well as the same breakdown for licensed users. It's also currently broken down by environment but the API limits are for your whole dataverse tenant (so every environment in your tenant). These reports will also help you identify which users may be hitting the daily limits for the license they have been assigned