Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

CDS performance issues over weekends

(0) ShareShare
ReportReport
Posted on by 34

I've created apps that read and write data to entities I created in CDS. The users of my apps however complain that the reading and writing of the data (typically through PATCH or FILTER functions) takes longer over weekends than during the week. I have not experienced this myself, but this has now been going on for a number of weeks, and every week I get complaints of performance issues over weekends. Are there reasons why this might happen?

Categories:
  • Patrick Hess Profile Picture
    on at
    Re: CDS performance issues over weekends

    DirkKotze,

     

    There isn't any known issue with performance over the weekend. If anything, you should see superior performance as these are not usually peak hours. This should mean that this isn't a resource availability issue, although always possible.

     

    This does depend on how busy your weekends are, though. It's still possible to overload an individual environment's CDS instance with too many requests. On the backend, these requests generate an async job that runs when it can. If you are making a substantial number of requests, you're going to generate more of these async jobs and create a backlog. Once you get a backlog, everything tends to slow down until the jobs are cleared out. This happens both in the cloud and on-premises.

     

    On that note, if there is something on-premises about your configuration (maybe you run some data through a gateway to another data source?) you'll want to look into that configuration first. By and large, the cloud should remain consistent so the breakpoint is often with the on-premises part of a given solution.

     

    It's possible that your app has some fine tuning you can apply to it. This shouldn't really affect any Read/Write actions against CDS but your expressions, the functions you're using, etc. can be a factor in how the app performs.

     

    For more:
    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview 
    https://powerapps.microsoft.com/en-us/blog/introducing-monitor-to-debug-apps-and-improve-performance/ 
    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/monitor 
    https://powerapps.microsoft.com/en-us/blog/monitor-now-supports-model-driven-apps/ 
    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/performance-tips 

     

    This is an especially good article, very in-depth and even goes under the hood:
    https://powerapps.microsoft.com/en-us/blog/performance-considerations-with-powerapps/ 

     

    This brings up another good point: Are we talking about a model-driven app (Dynamics) or a canvas app (PowerApps)? You create either one from the Maker Portal but model-driven apps are probably better addressed on the Dynamics forums as they run on separate functionality. We mostly handle canvas apps in this space.

     

    Licensing can be a factor in performance, do you know what your weekend users have assigned to them? If they're using trial/Standard licenses, they will always perform a little slower than if they have a standalone/Premium license assigned. We also have API limits and other thresholds in place that can be hit, similar to the async job issue I mentioned above.

     

    For more:
    https://docs.microsoft.com/en-us/power-platform/admin/powerapps-flow-licensing-faq 
    https://docs.microsoft.com/en-us/power-platform/admin/api-request-limits-allocations 
    https://go.microsoft.com/fwlink/p/?linkid=2085130 

     

    If you go through all of this and it's still not clear, you can always set up a support incident through the Power Platform Admin Center. We'll need reliable reproduction in order to further the issue but we can take a look.

     

    Let us know!

     

    Sincerely,
    Patrick

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 17

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics