Use Power Query to load data in Dataverse
Note
App in a Day instructor-led training
Continue your learning journey with the App in a Day instructor-led workshop. This course provides hands-on experience for building custom apps! Browse training events.
Important
Power Virtual Agents capabilities and features are now part of Microsoft Copilot Studio, after significant investments in generative AI and enhanced integrations across Microsoft Copilot.
Some articles and screenshots might 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.
Prerequisites
- 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