Internship
Student login
← Microsoft Power Platform learning path
Microsoft Power Platform · Module 2 of 10

Data sources and Dataverse

Where Power Platform solutions keep their data.

📖 Key ideas

  1. Apps can use Excel, SharePoint lists, SQL Server or Dataverse as data sources.
  2. Dataverse stores data in tables with columns and relationships, plus security roles.
  3. SharePoint lists are quick for simple team data; Dataverse suits larger, related, secured data.
  4. Choosing the right data source early saves rework later.
  5. Delegation limits mean some data sources cannot filter very large tables on the server.
💡 Real-life example: Like choosing between a notebook, a register and a proper office filing system: fine for small notes, but big records need the filing system.
Data sourceWhere an app reads and writes data
SharePoint listSimple table in SharePoint
RelationshipLink between two tables
DelegationLetting the data source do filtering