web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Rate Limit Exceeded - ...
Power Apps
Unanswered

Rate Limit Exceeded - SQL On Premesis

(1) ShareShare
ReportReport
Posted on by 795

This is starting to get a joke now.

Patching SQL on Premesis from powerapps and at about 200 records in.. Rate Limit exceeded!

 

Business software..  Not Personal software MS.

 

Categories:
I have the same question (0)
  • v-xida-msft Profile Picture
    on at

    Hi @Delid4ve,

    The "Rate Limit exceeded" error means that you hit the limit of API calls for the SQL Server connector.

    There is a limit in the API calls for the SQL Server connector -- 800 calls per 10 seconds. More details about the API Calls limit for connectors in PowerApps/Flow, please check the following article:

    https://veenstra.me.uk/2018/07/17/microsoft-flow-connector-limits/

    In order to fix this issue, please consider take a try to reduce the API calls from your app to the SQL Server connector.

    On your side, you should patch less records (e.g. 50 records) to your SQL table once time, and then patch the next 50 records, etc.

     

    Best regards,

    Kris

  • SJ-15052312-0 Profile Picture
    418 on at

    Hello,

     

    We are running into very similar issues.  From what I can find SQL Server limit is 100 calls per 10 seconds.  We want to roll out an app to a larger number of people.  The app needs to have real time data for certain values.  

     

    Did you find anything that has helper you over come these throttling limitations of PowerApps?  

  • Delid4ve Profile Picture
    795 on at

    This is where powerapps falls over and i feel definitely needs looking at for paying customers.

    The only thing i have been able to do is where i was using concurrent to process updates to multiple tables at once (reducing time for the end user) i have had to process them individually which adds about 2 minutes to the upload for me.  

     

    Since there is no 'Delay' or 'Sleep' function within commands i don't see any way to limit the rate, otherwise we could break the patch functions up and do say the first 50, wait, next 50 etc etc.. although this still doesnt solve the fact that multiple users could be executing the command together.

     

    I already load all data into collections for processing, not viable if it has to be real time, but if a couple of users patch at the same time then its just error after error.

     

    There has to be some form of limit to stop ddos etc but i do feel the rates need to increase significantly as if i'm getting them testing with 1 user, how do we expect to roll this out for multiple.

  • AFWright Profile Picture
    87 on at

    My users just started reporting this error as well. Azure SQL DB. Not even sure where to start troubleshooting this issue.

  • Frans_365CH Profile Picture
    231 on at

    I thought power apps were for low code developers? 
    But is power apps something more for professionals?

  • AFWright Profile Picture
    87 on at

    This particular issue came up when Microsoft premiumized SQL and other connectors in October of 2019. While that particular issue has not come up since, we get daily errors using the SQL connector with table writes colliding or just failing to write altogether. I would say, it's about 99% reliable at the moment. I have 60 active users on a single app. 

  • Frans_365CH Profile Picture
    231 on at

    Thank you, i have delete the connection and made a new and reconnect the tables again and i think the problem is gone now.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 793 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 333 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard