|
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 aka.ms/AccessAndPowerPlatform. |
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.
Preparation
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.
Procedure
-
Start Access, select Account, select Switch Account. The Account dialog box opens.
-
Make sure you are signed into Access with the same credentials you use in Power Apps.
-
Open the Access database for which you want to import or link Dataverse tables.
-
Select External Data > New Data Source > From Online Services > From Dataverse. The Get External Data – Dataverse dialog box opens.
-
In the Import data from Dataverse environment dialog box, select an instance URL from the list provided by the Global Discovery Service.
-
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
-
-
Select OK.
As a security precaution, you may be asked to re-enter your Power Apps account credentials. -
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.
