Create a Dataverse shortcut

Dataverse direct integration with Microsoft Fabric enables organizations to extend their Dynamics 365 enterprise applications and business processes into Fabric. This integration is accomplished through shortcuts, which can be created in two ways: through the PowerApps maker portal, or through Fabric directly.

Dataverse shortcuts are read-only. They don't support write operations regardless of the user's permissions.

For an overview of shortcuts, see OneLake shortcuts. To create shortcuts programmatically, see OneLake shortcuts REST APIs.

Create shortcuts through PowerApps maker portal

Authorized PowerApps users can access the PowerApps maker portal and use the Link to Microsoft Fabric feature. From this single action, a lakehouse is created in Fabric and shortcuts are automatically generated for each table in the Dataverse environment.

For more information, see Dataverse direct integration with Microsoft Fabric.

Create shortcuts through Fabric

Fabric users can also create shortcuts to Dataverse. When users create shortcuts, they can select Dataverse, supply their environment URL, and browse the available tables. This experience allows users to choose which tables to bring into Fabric rather than bringing in all tables.

Authorization

Dataverse shortcuts use a delegated authorization model. In this model, the shortcut creator specifies a credential for the Dataverse shortcut, and all access to that shortcut is authorized using that credential. The supported delegated credential types are organizational account (OAuth2) and Service Principal. The account must have the system administrator permission to access data in Dataverse Managed Lake.

Limitations

The following limitations apply to Dataverse shortcuts:

• Dataverse shortcuts are read-only. They don't support write operations regardless of the user's permissions.