Transcrito

Dataverse - Simply Explained

15 de jul. de 2026 · 18m 28s
Dataverse - Simply Explained
Descripción

Still running business data on Excel files and SharePoint lists that hit the 5,000-item wall? This episode explains Dataverse in plain English for Power Platform makers and IT pros: tables,...

mostra más
Still running business data on Excel files and SharePoint lists that hit the 5,000-item wall? This episode explains Dataverse in plain English for Power Platform makers and IT pros: tables, relationships, role-based security and how Power Apps, Power Automate and Power BI build on it. You will know when Dataverse is the right foundation and how to start your first data model.

In this episode
  • 00:00 – Why Dataverse exists
  • 02:32 – Tables: the foundation
  • 04:26 – One-to-many relationships and lookup columns
  • 06:36 – Many-to-many relationships and intersection tables
  • 08:34 – Role-based security, business units and teams
  • 11:02 – Dataverse versus SharePoint
  • 13:01 – Power Platform integration and AI
  • 15:46 – Getting started with your data model

Key takeaways
  • Dataverse is a managed relational data platform that handles tables, relationships, security and business logic so every Power Platform app, flow and report shares one foundation.
  • Lookup columns, enforced referential integrity and role-based security with business units, teams and column-level security make Dataverse far more robust than spreadsheets or SharePoint lists.
  • Use SharePoint for simple trackers and documents, choose Dataverse for business-critical systems of record, and start with standard tables and a data model planned on paper.

Worth quoting

“Here's something important to understand. Security and dataverse is additive, not subtractive. If a user has two roles, they get the most permissive access from either role.” – Mirko Peters (09:40)

“The golden rule of dataverse security is this, don't assign system administrator to everyone. That role gives full access to everything in the environment.” – Mirko Peters (10:23)

Explore more on M365.FM
  • Episode page: the full episode with chapters, quotes and a short FAQ on Dataverse
  • Dataverse – the episode's subject: tables, relationships, role-based security and when to use it
  • Power Platform – the platform whose apps, flows and reports all share Dataverse as their data layer
  • SharePoint – compared directly with Dataverse on cost, scale, relationships and security, plus a hybrid pattern
  • Microsoft Lists – SharePoint lists as the step up from Excel that hits the 5,000-item view threshold
  • Related episode: Dynamics 365 Dataverse Integration - Simply Explained

Follow and rate M365.FM in your podcast app, and join the free M365 community at m365con.net.

Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.
mostra menos
Información
Autor Mirko Peters M365, Azure & AI
Organización m365 FM
Página web www.m365.fm
Etiquetas

Parece que no tienes ningún episodio activo

Echa un ojo al catálogo de Spreaker para descubrir nuevos contenidos.

Actual

Portada del podcast

Parece que no tienes ningún episodio en cola

Echa un ojo al catálogo de Spreaker para descubrir nuevos contenidos.

Siguiente

Portada del episodio Portada del episodio

Cuánto silencio hay aquí...

¡Es hora de descubrir nuevos episodios!

Descubre
Tu librería
Busca