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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Impact of Number of vi...
Power Apps
Unanswered

Impact of Number of views on MDA performance

(0) ShareShare
ReportReport
Posted on by 9

1. My model driven app has more than 200 views for an entity(table) which might increase to 300 or 400 in future. I wanted to know if having so many views in MDA impact its performance?

2. I wanted to know if the when is data for fetched and loaded  for each view of an entity? is it onload of the MDA or the onload of view(after clicking on the view from drop down) 

 

If "number of views" impact MDA performance then what can be possible solution:

1. restricting views based on user security role/ security team.

 

if anyone knows how to implement this solution let me know, or if there is any other way to reduce impact of views on MDA performance

 

Categories:
I have the same question (0)
  • ANB Profile Picture
    7,252 Super User 2026 Season 1 on at

    Hi @Akanksha09 , Personally, I have never had such situation with so many views in MDA, however there could be performance issue for app. Now to confirm whether the app which has 200 to 400 views is actually having performance issue wrt views, for that I can suggest one preview feature: Performance insights (preview)

     

    This is how you can access this page for MDA.

     

    ANB_0-1706192553409.png

     

    Please check this feature and try to explore it.

     

    -----------------------------------------------------------------------------------------------------------------------------

    I hope this helps.

    Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

    Thanks,
    ANB



     

  • Akanksha09 Profile Picture
    9 on at

    I am trying to find resources which lets me know how views are working in backend. It seems we can create, edit and update views using FetchXML also. in the sreenshot it says that views are "saved queries" . If data for each view is fetched and loaded only "on click" of the view and only queries are attached to the views when MDA loads, then no amount of views should affect the performance of the app, as data wont be fetched and loaded again for all the views at onload of the MDA. 

     

    Akanksha09_0-1706193052011.png

     

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

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 April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 1,027

#2
Valantis Profile Picture

Valantis 644

#3
11manish Profile Picture

11manish 626

Last 30 days Overall leaderboard