Trascritto

Dataverse - Simply Explained

15 lug 2026 · 18 min. 28 sec.
Dataverse - Simply Explained
Descrizione

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 di più
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 meno
Informazioni
Autore Mirko Peters M365, Azure & AI
Organizzazione m365 FM
Sito www.m365.fm
Tag

Sembra che non tu non abbia alcun episodio attivo

Sfoglia il catalogo di Spreaker per scoprire nuovi contenuti

Corrente

Copertina del podcast

Sembra che non ci sia nessun episodio nella tua coda

Sfoglia il catalogo di Spreaker per scoprire nuovi contenuti

Successivo

Copertina dell'episodio Copertina dell'episodio

Che silenzio che c’è...

È tempo di scoprire nuovi episodi!

Scopri
La tua Libreria
Cerca