Power Apps Data Sources Ranked! Which is best? 🥇

#powerapps #PowerPlatform #CanvasApps #ModelDriven

In this video, we dive deep into the world of PowerApps data sources, ranking them based on their performance, scalability, and overall suitability for different use cases. We discuss the top five data sources for PowerApps, including SharePoint, SQL Server, Dataverse, and more. We also touch on why Excel might not be the best choice for your PowerApps data source. Whether you're a PowerApps beginner or an experienced developer, this video will provide valuable insights to help you make the best decision for your project.

0:00 Intro
0:38 5th best data source
2:18 4th best data source
2:54 3rd best data source
6:51 2nd best data source
7:43 1st best data source
9:36 Licensing chat
10:46 Help choosing

Up your Power Apps Skills Today!

Need some help on something you are working on, contact us!

PowerApps911

Let's connect on social!

[practicalpowerapps]

You will see this link referred to on the forum a lot - just used it today. I also loved your comments and ranking of SharePoint and the 80% use comment - that would be my judgement from forum posts as well. I have never needed to use anything else in the five years I have been writing apps - it is a good solid reliable platform and better still out of the box at no extra cost.
Warren Belz

[chrislloyd]

What a relief. Just been migrating an SP-based Powerapp to Dataverse so your video is very reassuring. I’m seeing the performance improvement too.

[saeedsm]

100% agree! I am a SQL expert but I found out dataverse just goes better with power platform and actually I have never used any data sources but dataverse to build power platform apps.

[EugeneNaumenko_Music]

Thanks Shane! Good video for sharing with people who doesn't know differences of data sources, because for many of citizen developers SharePoint is only one thing.

[microfuel]

One important point about SQL-server is that you can run it on-prem and have all the data in your own data center and use the rapid application development capabilities of the power platform without moving everything to the cloud.

[GroverParkGeorge]

One more reason to adopt Dataverse, IMO, is the ability to work Offline. I don't know if any other data source is supported for offline use, but the scenarios where I would encourage adding PowerApps to your toolkit (I'm a retired Access developer) often involve remote locations--think warehouses, job sites, and such--physical locations where an internet connection is not guaranteed.

Scanning barcodes in a warehouse for Stock Take comes to mind as a prime example.

[oluwatobipaul]

I totally agree with you ranking. Thank you Shane

[Tony-yzyj]

Spot ON!

I am literally having to deal with the data source problem right now. I developed an App that has Dataverse backend and did not realize the cost of the Premium. Well working with a company that has 6K+ users (estimated 1500 that would use my app) I had to nix the idea and go back to working with SharePoint instead. Here is my scenario for anyone else to learn from my mistake...

1. The app is approval flow is only a temporary solution to help our company get off of MOSS and SP 2010 servers (YUCK).
2. Dataverse is great for everything Shane says, but the premium licensing per user per month was going to add up. Until I can save the company money elsewhere, it is not easy to convince them to spend money on the Premium.
3. The app/SharePoint list will see about 5-10 entries a day with the possibility of an occasional bulk import of data.
4. This interim app is only in place until end of 2024. I am confident that speed will not be a huge issue during this time as long as I keep the control that I am doing with my Gallery loads and how I filter the data.

[edjk]

I’ll head over to your website and have a look keep this good Contant coming

[jesus.moreno]

gracias Shane ... you are the best in this topic, ,, I trust you!!

[hjpwyuk]

Love the video!. Thank Shane! Although I have watched most of your videos and have learned a lot from them, I have to disagree a little bit with the ranking. I think the order from 5 to 1 is Excel, SharePoint, almost anything else (1000+ connectors), SQL, Dataverse. This is based on all of the reasons you provided regarding SharePoint, delegation, not a RDBMS, problems with large amount of data.... yada, yada.

[paspuggie]

After 20 years of using Excel and 5 years developing automated Power Query solutions, I am an Excel geek, I love Excel.
However, I've literally just started my Power Apps journey in the past few weeks (late to the party I know) and just watching your videos (with others I mentioned in a tweet including you Shane) I have already told my bosses the way to go is (drum roll...), exactly the same priority in your list.
I've said we should be looking at Dataverse moving forward and not Excel or even Lists (albeit I have to start somewhere to learn the basics).
Just seems more logical?
So, as a numpty beginner I agree with your results :)

[brianmullaly]

this ranking helps, thx. need the security, scalability, features, etc, but have been on the fence committing to dataverse for solution

[CheapCheerful]

Why are'nt I subscribed yet! Done! Brilliant. PowerApps is really taking off these days with Low Code and GPT being a match made in heaven!

[svesamm]

Till Dataverse and SQL become free and open or at least reasonably priced specially for for mid/big firms, will continue to use Excel (which outperforms Dataverse in some cases - my actual testing) and SP.

[AlistairCreenz]

Nice summary Shane, no surprises which is good. But I feel you could have included a mention for dataverse for teams. I use this extensively without premium license. I think dataverse fot teams is no 1 (taking cost into account).

[tonykalok]

nice share, been struggling with Sharepoint list on delegation issue, considering the case for far more than thousands of record, it seems not working on filtering/sorting & searching... Any suggestion? Should the data source be changed? thank you.

[sudokujunkie]

Thank you for making this. It's rare that I get requests to build an app. But, when I do, my employer says we can use SharePoint for the back end. I tell them no and why. Now, I can add your voice. Hopefully, they'll believe one of us.

[Yinusa]

fantastic video thank you for all you do

[terencealmeida]

Hi Shane,

We generally get a threshold limit error once the records in an sharepoint list exceed 25000 records which restricts us to add or delete any column fields.. therefore it was recommended to use an excel file saved under a sharepoint folder, apparently i was informed that in an excel we can store more than records without any threshold limit error. Let me know of your views in this regards.