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

Announcements

Welcome to the Power Platform Communities
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
Answered

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,189 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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 519 Most Valuable Professional

#2
11manish Profile Picture

11manish 489

#3
Haque Profile Picture

Haque 327

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