Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Advice on data source for PowerApp with large amount of Data

(0) ShareShare
ReportReport
Posted on by

Hi friends,

Was hoping to get some advice on what is the best datasource to use for an app that has a large amount of data.

The app is currently in use and all data is being stored on SharePoint.

 

  1. The app allows users to capture orders which are then allocated to someone to complete (ListName: Orders)
  2. There are currently 1000-3000 orders captured per day
  3. In order to keep the system quick, there is a flow that runs a few times a day that archives orders in another list (ListName: OrdersArchive)
  4. The OrdersArchive currently holds about 800 000+ captured over the 1.5 years
  5. There are other lists now in use and these are also growing

Although SharePoint can handle the storage of this, the issue now is that querying, analysing, exporting etc of the data has become rather difficult.

 

There also a few flows that run to send summary reports and the eventuality is that amount of data will become a blocker.

 

The idea is to move it to Dataverse or SQL, though it seems Dataverse is the winning option for now taking into account the barriers to enter with Azure SQL and how enterprise IT manages their process as well as the options you have with analyzing data.

 

Any advice on this? Should we stick it out in SPO? How many rows can Dataverse actually handle?

 

Appreciate the support!

 

 

  • aadilg Profile Picture
    aadilg on at
    Re: Advice on data source for PowerApp with large amount of Data

    Thank you so much for the great advice. Hoping to go ahead with DV!

  • BrianS Profile Picture
    BrianS 2,407 on at
    Re: Advice on data source for PowerApp with large amount of Data

    People will always find ways to mess up the data 😁

    It is easier with DataVerse since you have more granular control over permissions. When multiple apps use the same data, in any container, you just have to make sure that data being written by one app doesn't cause a different app to malfunction. Good communication between people writing the apps and a good "Data Bible" are the keys there

  • aadilg Profile Picture
    aadilg on at
    Re: Advice on data source for PowerApp with large amount of Data
    Thanks for your advices. In terms of number of usability, multiple apps will be hosted in the same environment and will all use the same Dataverse for storage. Have you seen issues where people misuse tables or anything that can cause multiple apps on the same environment to have issues?
  • Drrickryp Profile Picture
    Drrickryp on at
    Re: Advice on data source for PowerApp with large amount of Data

    @aadil-gl 

    I agree with @BrianS  and would vote for Dataverse. 

  • BrianS Profile Picture
    BrianS 2,407 on at
    Re: Advice on data source for PowerApp with large amount of Data

    I would say that Dataverse would be the winner. It will hold a million rows, I believe, around 2 GB.

    Also - there is no "connector" so the tie-in to PowerApps in built-in - should be quicker

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard