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

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dataverse database per...
Power Apps
Unanswered

Dataverse database performance from Power Apps

(0) ShareShare
ReportReport
Posted on by Pardha

Hi, 

Someone please help me to share approximate stats with respect to Dataverse and Power Apps.

The table has around 50 columns and around 1,00,000 rows. 

I think we can display the data by filtering and implementing flexible pagination. 

If I have to fetch around 1000 records at a time, will there be any performance impact?

Also, I have few complex queries like grouping and summary calculation. 

In this scenario, how many seconds it would take approximately to run these complex queries. 

If anyone has any general idea on the performance, please share details. 

 

Thanking you in advance.

-Pardha

 

 

Categories:
Microsoft Dataverse with Power Apps
I have the same question (0)
  • ivan_apps Profile Picture
    ivan_apps 2,187 Moderator on at

    I don't have specific stats for you but dataverse will lazy load your data when delegated. Basically it will load it in batches of 100 when you have a delegable filter query, and will keep loading as you scroll down.

    If you have a non-delegable query, it will retrieve at most 2000 records.

    Performance with the above criteria is good, no noticeable lag in my opinion but it does depend a bit on your network speeds.

     

    Now if you want to cache your data locally and load 1mil records with 50 columns each... i think you'll see some performance issues.

    If you are working with the data, i would recommend to create more filters so users can work with discreet smaller chunks. Add a date range or dropdown or something else to bring back less results.  I don't think you'll have to update 100,000 records all at once, I would probably say you need to rethink your use cases if so.

     

    If you are reporting on this data, use Power BI - it will handle your records cleaner and filter things easily and give you more transformation options. Performance is quite good as well.

     

    Lastly, consider using Model-Driven Apps for large and complex data sets. You'll have more out-of-the-box filtering and ad-hoc reporting capabilities and run into much fewer performance/delegation issues.

  • Verified answer
    Pardha Profile Picture
    Pardha on at

    Thank you, Ivan. It helps.

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

News and Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans