Episode Details

(00:00:00) The SharePoint Database Myth
(00:00:58) The Illusion of SharePoint as a Database
(00:01:38) SharePoint's Limitations and Performance Issues
(00:04:02) The Scale Myth: When SharePoint Fails
(00:10:06) Relationships and Data Integrity: SharePoint's Achilles' Heel
(00:15:38) Security: A False Sense of Protection
(00:18:06) Lifecycle Management: The Hidden Costs
(00:20:08) The Licensing Trap: Free Isn't Always Cheap
(00:21:23) The Final Verdict: SharePoint vs. Real Databases

In this episode of M365.fm, Mirko Peters tears down the myth that SharePoint can act as a real database for Power Apps and shows why “we’ll just use a SharePoint list” quietly destroys performance, scalability, and data integrity as your app grows. He contrasts what proper databases like SQL Server and Dataverse actually do—schemas, indexing, relationships, execution plans, and concurrency control—with what SharePoint was built for: collaboration, documents, and light metadata, not transactional systems. You will hear why using SharePoint as a free “backend” feels fine for a few hundred records but quickly becomes a performance time bomb once lists hit thousands of items and multiple users start hammering the same data.

Mirko dives into the delegation wall and the scale myth behind Microsoft’s “30 million items” number, explaining how Power Apps ends up pulling data client‑side, turning every user’s device into a fake database server and triggering slow galleries, long load times, and random throttling. He unpacks how limited indexing, shallow lookups, and lack of real referential integrity create “lookup chaos,” data drift, and silent corruption when you try to treat SharePoint like SQL—especially once you add multiple related lists and heavy filters. Through real‑world stories of “CRM on SharePoint lists” that worked for a month and then fell apart at 5,000+ records, he shows how physics, not Wi‑Fi, kills your app.

You also get a practical architecture playbook: when a SharePoint list is perfectly fine (small, low‑risk apps, simple tracking, collaboration scenarios) and when you must move to Dataverse or SQL before launch. Mirko outlines how to spot the tipping points—growing record counts, complex relationships, multi‑user edits, reporting needs—and how to plan a Dataverse migration path before tech debt, performance complaints, and governance gaps explode. He shares concrete patterns for data modeling, concurrency handling, and performance testing so your next Power App is built on an engine, not on a filing cabinet pretending to be one.

WHAT YOU WILL LEARN

• What makes a real database (schema, indexes, relationships, execution plans) vs. what SharePoint actually is.
• How delegation limits, 2,000‑item ceilings, and throttling turn large SharePoint‑backed apps into performance nightmares.
• Why lookup‑heavy designs create “lookupchaos,” data inconsistencies, and slow, chatty OData queries.
• When SharePoint lists are fine and when you must move to Dataverse or SQL for serious Power Apps workloads.
• How to plan models, scalability, and migrations so you avoid rebuilding your app once it becomes successful.