Load/export data and create data views in Dataverse

Functional Consultant
Dynamics 365
Microsoft Power Platform
Microsoft Dataverse
Power Apps

Dataverse lets you load data into or export tables from other tables by using Microsoft Excel. You can also create views to quickly review data that is stored within a table.

Learning objectives

In this module, you will:

  • View data within a table.
  • Create or edit views of data in a table.
  • Load data into a table.
  • Export data from a table.
  • Add, update, or delete data in a table by using Excel.
  • Import data using Power Query in Maker Portal
  • Generate a new dataflow from an Excel Template
  • Learn about dataflows and Azure integration


A basic understanding of what a database is and its role within a software solution.