Can't create link to fabric from dataverse

Question

We want to try creating Link to Fabric from Dataverse. We select a table from D365 Finance & Operations but got this error message while creating workspace & lakehouse:

"We ran into an issue: Creation of Synapse Link failed. You can try again, if this issue persists please contact support."

We tried to create a new table shortcut from the lakehouse and got this error message:

"Error 404 - This Dataverse environment does not appear to be configured for use with Fabric. Follow these instructions to setup Dataverse https://go.microsoft.com/fwlink/?linkid=2260624."

Our user is a system administrator in Dataverse, admin workspace in the destination workspace, and Fabric capacity admin. Dataverse is in Asia region, while Fabric is in Southeast Asia. We connect using organizational account.

Previously, we tried to create a link to Fabric from the same Dataverse environment to a workspace with a trial capacity and it worked. We already unlink the previous one. Right now we want to recreate the link to a workspace in an F128 capacity.

We also have enabled link to Fabric for Dataverse tables (not D365 table) for another Dataverse environment in the same region and it works fine with the same roles and the same connection etc.

Why am I getting these errors?

How can I create the link to Fabric successfully?

Answer 1

The errors are caused by capacity/geography constraints and by the Dataverse environment not being correctly linked/configured for Fabric in the target workspace.

From the documented behavior:

1. Capacity must match the Dataverse environment geography
   • Link to Fabric requires a Power BI Premium or Fabric capacity in the same geography as the Dataverse environment. Initially it enforced same region, and after April 30, 2024 it enforces same geography instead of region.
   • If the capacity is not in the required location, workspace creation and link setup can fail with errors like the ones seen.
   • The error table states: “You must have Power BI premium or Fabric capacity in the same region {Region}. You can also get a Fabric trial. You won't receive this error after April 30, 2024. Instead, you're shown an error if you don't have capacity in the same geography.”
2. Dataverse environment must be properly configured and linked
   • The 404 error “This Dataverse environment does not appear to be configured for use with Fabric” indicates that the environment is not fully configured for Link to Fabric for that workspace/lakehouse.
   • Link to Fabric is created and managed from Power Apps → Synapse Link (formerly Microsoft OneLake link). The wizard must complete successfully to create the Fabric workspace, lakehouse, and shortcuts.
   • If the initial creation fails (for example, due to capacity/geography issues), the lakehouse will not be correctly wired to Dataverse, and direct shortcut creation from Fabric will fail with the 404 message.
3. Role and permission requirements
   • To link to Fabric, the user must:
     • Have the System Administrator security role in Dataverse.
     • Be a Power BI Capacity Administrator or have contributor access to a capacity in the same geography as the Dataverse environment.
     • Have permission to create workspaces in Power BI Admin portal (Tenant settings → Workspace settings → Create workspaces).
   • If workspace creation in Fabric fails, the troubleshooting guidance is: “Creation of Fabric workspace failed. You can try again. If this issue persists contact Microsoft customer support with the correlation ID.”
4. Dynamics 365 Finance and Operations tables behavior
   • When creating a Fabric link, only non‑system Dataverse tables with Change tracking = Yes are auto‑selected.
   • Finance and operations apps tables are not auto‑selected. They must be added via Manage Tables in the Microsoft OneLake/Azure Synapse Link profile after the link is created.
   • If the base link to Fabric is not successfully created, F&O tables cannot be added.

To create the link to Fabric successfully for this environment:

1. Verify capacity geography
   • Confirm that the F128 Fabric capacity is in the same geography as the Dataverse environment. If it is in a different geography, create or use a capacity in the correct geography and retry the Link to Fabric wizard from Power Apps.
2. Recreate the link from Power Apps
   • In Power Apps (make.powerapps.com), go to Synapse Link.
   • Start the Link to Fabric wizard for the Dataverse environment.
   • Ensure the selected workspace is backed by the correct Fabric capacity (same geography) and that the user has contributor or capacity admin rights.
   • Complete the wizard so that the workspace and lakehouse are created and initialized. Do not create shortcuts directly from Fabric until this completes.
3. Wait for initial sync and fix “Unidentified” tables if needed
   • After creation, it can take up to 60 minutes for initial sync and conversion to Delta Parquet. During this time, tables may appear as unidentified in the lakehouse.
   • If tables remain unidentified for several hours, go back to Synapse Link in Power Apps, select the Microsoft OneLake/Azure Synapse Link profile, and choose Refresh Fabric Links to refresh table metadata.
4. Add Dynamics 365 Finance and Operations tables
   • Once the link is healthy, open the Microsoft OneLake/Azure Synapse Link profile in Power Apps and use Manage Tables to add the F&O tables. They are not auto‑selected.
5. If workspace creation still fails
   • Confirm with the Power BI tenant admin that the user is allowed to create workspaces (Power BI Admin portal → Tenant settings → Workspace settings → Create workspaces).
   • If the error persists after verifying geography and permissions, follow the guidance to contact Microsoft customer support with the correlation ID from the failure message.

---

References:

• Troubleshooting common issues with link to Fabric
• Link to Microsoft Fabric

Answer 2

Hello !

Thank you for posting on MS Learn Q&A.

The issue is probably not your Dataverse system admin role but the Fabric link not being created correctly for the F128 backed workspace.

The Fabric workspace must be backed by a premium or fabric capacity in the same required region as the Dataverse environment and the user must be capacity admin or have contributor access to that capacity.

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/fabric-troubleshoot

Create the link from Power Apps / Dataverse not from Lakehouse then new shortcut. The wizard is what creates the Lakehouse, SQL endpoint, semantic model, connection, and shortcuts.

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-view-in-fabric

Create the base link to Fabric first then add F&O tables since they are supported but they are not auto selected during the initial Fabric link creation. After the base link is created, go to Power Apps then Azure Synapse Link then Link to Fabric the, Manage tables and add the F&O tables there.