Migrate with the Fabric Migration Assistant for Data Warehouse - Unable to complete migrate steps

[Sudharsan1401]

Hi everyone,

I'm trying to create a migration activity in Microsoft Fabric using a DACPAC file that contains database objects. However, I'm encountering the following error during the process
image (15).png

While creating a migration activity in the fabric using the DACPAC file (database objects), Encountering below mentioned error,

I've verified that the DACPAC file is valid and contains the necessary schema objects. Has anyone faced a similar issue or knows what might be causing this?

Any guidance or suggestions would be greatly appreciated.

Thanks in advance!

Sudharsan Kalyanakumar

[v-tsaipranay]

Hi @Sudharsan1401 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. 

Thank you.

[anilgavhane]

Common Causes of Migration Failure

1. Unsupported T-SQL Features
   Some objects in your DACPAC may use T-SQL syntax or features that aren't supported in Fabric Data Warehouse. These often include:
• Computed columns with complex expressions
• Certain types of constraints or triggers
• Deprecated SQL types
2. Dependency Chain Issues
   If dependent objects (like views or procedures) rely on primary objects that fail to migrate, the whole chain can break. You’ll need to fix the primary object first before dependent ones can be processed.
3. Metadata Conflicts or Corruption
   Even if the DACPAC is valid, metadata might not align with Fabric’s schema expectations. This can cause silent failures or vague error messages.

Recommended Steps to Resolve

• Use the “Fix Problems” Step in the Migration Assistant
  This feature helps identify which objects failed and why. It guides you to fix primary objects first before dependent ones.
• Simplify the DACPAC
  Try creating a DACPAC with only a few basic tables and views to isolate the issue. If that works, gradually add more objects to identify the problematic ones.
• Check for Compatibility
  Review your DACPAC for unsupported SQL types or features. You may need to modify the schema before migration.

[v-tsaipranay]

Hi @Sudharsan1401 ,

Thank you for confirming that the “Users can create Fabric objects” option is enabled in your tenant. Since the error message still appears, it suggests that another feature flag or workspace setting may be preventing the Data Warehouse object from being created during the DACPAC migration.

A few things you can check:

• Make sure the workspace you're using is assigned to a Fabric capacity, not just a shared or free workspace, since migration requires the ability to create a new Data Warehouse in Fabric.
• Check with your Fabric or Power BI admin to confirm whether the Warehouse migration from DACPAC feature has been fully rolled out for your tenant, as Microsoft is gradually enabling some preview features.
• If all necessary settings are enabled but you still encounter the error, consider reaching out to Microsoft Fabric support, as a tenant-level feature flag might need to be activated on the backend.

Please try the above checks and hope this helps you resolve your problem. Please feel free to reach out for further questions.

Thank you.

[v-tsaipranay]

Hi @Sudharsan1401 ,

I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.

Thank you.

[v-tsaipranay]

Hi @Sudharsan1401 ,

Thank you for reaching out to the Microsoft fabric community forum. Also thank you @tayloramy for helful resposne.

The error message “Required feature switch disabled” means that the issue is related to a Fabric tenant-level setting, not your DACPAC file. When performing a migration, Fabric needs to create a new Data Warehouse as the target. If the Fabric admin switch is turned off, users are unable to create new Fabric objects like Warehouses or Lakehouses, resulting in this error. To fix this, your Fabric (Power BI) Admin should enable the Fabric feature switch in the Admin Portal.

You can find detailed instructions in the Microsoft documentation here: Enable Microsoft Fabric for your organization - Microsoft Fabric | Microsoft Learn Once enabled for the necessary security groups or the organization, you should be able to proceed with the migration.

Hope this helps, please feel free to reach out for any further questions.

Thank you.

[tayloramy]

Hi @Sudharsan1401, 

This error appears to be saying that a required feature is disabled in the Fabric Admin Portal. 
Is the "Users can create Fabric Objects" feature enabled in your tenant? 

If this was helpful, consider giving Kudos. If I solved your problem, please mark this as a solution. 

[Sudharsan1401]

Hi @tayloramy , Yes its enabled

[spaceman127]

Hi @Sudharsan1401,

Ok,

Although this message is pretty clear, what rights do you have in the workspace?
Is the switch set to the entire organization or to a specific group?

Best regards