Access integration with Microsoft Power Platform

Important

This content is archived and is not being updated. For the latest documentation, go to What is Microsoft Dataverse?. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview General availability
Admins, makers, marketers, or analysts, automatically Nov 2, 2021 To be announced

Business value

Microsoft Access users can now choose to migrate their databases to Microsoft Dataverse. This will provide rich data possibilities through the use of Microsoft Power Platform while allowing users to continue managing their data using existing Access forms.

Feature details

The Microsoft Access migration tool will simplify and automate the process of moving data to Microsoft Dataverse or Microsoft Dataverse for Teams, using a few simple steps.

  • Users can migrate data, tables, and relationships into Microsoft Dataverse or Dataverse for Teams.
  • Migrated data and schema can be used with Power Apps, Power Automate, Power Virtual Agents, and Power BI.
  • Access users will be able to continue using their desktop client to manage their data, in addition to using the Microsoft Power Platform clients.
  • Preview will support 80 percent of available Access types for migration, and provide support for 1:M and self-referential relationships, with more data types and relationships coming in the future.

See also

Learn about Access integration with Microsoft Power Platform (video)

Migrate Microsoft Access data to Microsoft Dataverse (docs)