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.
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!
Thank you so much for the great advice. Hoping to go ahead with DV!
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
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