Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Note    This feature is in General Availability (GA) in the Microsoft 365 Monthly Release Channel as of May 2022. If you are on the Microsoft Semi-annual Enterprise Channel, it is available in December 2022. For more information on how to participate, see

You can link to any Dataverse table from Access, not just the ones that you migrate. Perhaps the table is already used in a pre-built Power app. Or the app is used with other products such as Excel, SharePoint, or SQL Server. You can enhance the app with Access by linking to those tables and creating forms, reports, queries, and other objects.


Make sure you set up your Access and Power Apps environment first. For more information, see the "Before you begin" section in Migrate Access data to Dataverse.


  1. Start Access, select Account, select Switch Account. The Account dialog box opens.

  2. Make sure you are signed into Access with the same credentials you use in Power Apps.

  3. Open the Access database for which you want to import or link Dataverse tables.

  4. Select External Data > New Data Source > From Online Services > From Dataverse. The Get External Data – Dataverse dialog box opens.

  5. In the Import data from Dataverse environment dialog box, select an instance URL from the list provided by the Global Discovery Service.

  6. Do one of the following: 

    • Import       Select Import the source data into a new table in the current database. 

    • Link       Select Link the data source by creating a linked table

  7. Select OK

    As a security precaution, you may be asked to re-enter your Power Apps account credentials.

  8. In the Link Tables or Import Objects dialog box, under Tables, select each table that you want to link or import, and then click OK.

See Also

Migrate Access data to Dataverse

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!