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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / ERROR: code":&quo...
Customer experience | Sales, Customer Insights,...
Suggested Answer

ERROR: code":"0x80072322","message":"Number of requests exceeded the limit of 6000 over time window of 300 seconds

(0) ShareShare
ReportReport
Posted on by Community Member

I want to import from on-premise SQL server to Dynamics 365 CE dataflows, and so as to import data into custom entity. During my PowerQuery import data from SQL server, it hit following error. I have 30k record in SQL server.

Does anyone know about workaround?

Error Message:

{"error":{"code":"0x80072322","message":"Number of requests exceeded the limit of 6000 over time window of 300 seconds.","innererror":{"message":"Number of requests exceeded the limit of 6000 over time window of 300 seconds.","type":"Microsoft.Crm.Extensibility.Throttling.ThrottlingRateLimitExceededException`1[[Microsoft.Crm.Extensibility.ODataV4.Throttling.ThrottleKey, Microsoft.Crm.Extensibility, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]","stacktrace":" at Microsoft.Crm.Extensibility.ODataV4.Throttling.ODataThrottlingHandler.<ThrottleBurstRequestAsync>d__9.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.Crm.Extensibility.ODataV4.Throttling.ODataThrottlingHandler.<ThrottleRequestAsync>d__8.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.Crm.Extensibility.ODataV4.Throttling.ODataThrottlingHandler.<>c__DisplayClass7_0.<<SendAsync>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.<ExecuteAsync>d__11`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.<ExecuteAsync>d__6`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.Crm.Extensibility.ODataV4.Throttling.ODataThrottlingHandler.<SendAsync>d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.HttpServer.<SendAsync>d__0.MoveNext()"}}}

I have the same question (0)
  • Suggested answer
    RajuB Profile Picture
    RajuB on at

    I think you're hitting the Dynamics 365 throttling limits (though the numbers in the message are slightly different.

    This article docs.microsoft.com/.../api-limits  gives more information and also some workarounds. However, the workarounds are mostly how to handle the throttling message in code

  • Community Member Profile Picture
    Community Member on at

    Hi RajuB, I really thank you for your information. As you said the link shows while retry code, though I would like to know how to handle the error in dataflows because I cannot find out any ways how to handle it in dataflows environment.

    Does anyone know workaround in dataflows?

  • Suggested answer
    RajuB Profile Picture
    RajuB on at

    In case , If you are using the dataflows using the power bi power query there are some consideration and limitations:

    There are a few known limitations to using Enterprise Gateways and dataflows:

    Each dataflow may use only one gateway. As such, all queries should be configured using the same gateway.

    Changing the gateway impact the entire dataflow.

    If several gateways are needed, the best practice is to build several dataflows (one for each gateway) and use the compute or entity reference capabilities to unify the data.

    Dataflows are only supported using enterprise gateways. Personal gateways will not be available for selection in the drop down lists and settings screens.

    You might start opening thread with PowerBI team for more assistance on this data-flow.

    Additional info: docs.microsoft.com/.../service-dataflows-on-premises-gateways

    Thank you for using the Dynamics Community,

    Raju

    Dynamics 365 Support

  • Community Member Profile Picture
    Community Member on at

    Hi Raju, I appreciate your response.

    I do not think I am using PowerBI dataflows, using PowerApps dataflows. There might be same consideration and limitation for PowerApps dataflows as PowerBI. Though that limitation (6k over 300sec window) is severe when building hybrid production environment between on cloud and on-premise SQL without realistic workaround for dataflows because it is normal for SQL server to have tables with over 10k records.

    Thanks,

    Toshi

    4478.untitled.png

  • Suggested answer
    RajuB Profile Picture
    RajuB on at

    Thanks for it.

    if its also using the powerapps dataflows and in order to handle the data integration function , Due to the nature of databases that handle large amounts of data, the number of 6000 records is insufficient.  

    you can provide your request in the powerusers.microsoft.com/.../   based on the voting , the feature request get prioritized and validate the possibilities to handle and provide the inputs and suggestions on the same.

  • Community Member Profile Picture
    Community Member on at

    Hi Raju, thanks.

    powerusers.microsoft.com/.../391414 was reported.

    For my side, I created MS scheduled Flow to import SQL record into CDS for workaround.

  • Suggested answer
    RajuB Profile Picture
    RajuB on at

    Thats good to hear. Thanks for the update!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 70 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 33 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans