Use Power Query to load data in Dataverse

App Maker
Functional Consultant
Microsoft Power Platform
Power Query
Power Apps
Microsoft Dataverse


App in a Day Instructor-Led Training

Continue your learning journey with App in a Day hands-on Instructor led workshop. This course provides hands-on experience for building custom apps! Browse training events.


Power Virtual Agents capabilities and features are now part of Microsoft Copilot Studio following significant investments in generative AI and enhanced integrations across Microsoft Copilot.

Some articles and screenshots may refer to Power Virtual Agents while we update documentation and training content.

Synchronizing data from different sources to a Microsoft Dataverse table can seem overwhelming. To help Power Apps users with these processes, the users can create Dataverse dataflows. Dataflows use the Power Query interface that is accessible in Power Apps Studio to provide a guided approach. Also, in this module, you'll explore how Power Query can help load data into Dataverse tables.

Learning objectives

In this module, you will:

  • Understand the different data source categories available when using Power Query.
  • Know how to import data into a Dataverse table by using Power Query.
  • Understand the different refresh options available.


  • A Power Apps license
  • Access to Microsoft Dataverse
  • Access to Microsoft Excel
  • Access to OneDrive for Business
  • A basic understanding of what a database is and its role within a software solution