Forum Discussion

Rakuka's avatar
Rakuka
Frequent Visitor
3 months ago
Solved

Issue while trying to use an on-premises SQL Server source in Microsoft Fabric pipeline

Hi Fabric team, Good morning I am facing an issue while trying to use an on-premises SQL Server source in Microsoft Fabric through an on-premises data gateway.   Environment Fabric trial capacit...
Data Pipeline
  • v-tejrama's avatar
    v-tejrama
    3 months ago

    Hi Rakuka ,

     

    I would take a moment to thank Lodha_Jaydeep  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

    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.

tayloramy's avatar
tayloramy
Super User
3 months ago

Hi Rakuka,

 

That is really unfortunate that it is not available in your region. 
Moving Fabric items between regions is not trivial, you basically need to delete everything and start again, there is no automatic migration process... 

 

The Power BI items can be exported and re-imported into the new region, however anything Fabric related like halekhouses, pipelines, dataflows, etc. cannot be. 

 

Here's the documentation: 

  • Workspaces with non-Power BI Fabric items can't be moved between regions. You must delete all the non-Power BI Fabric items before moving a workspace to a different region. Once the workspace is moved, it can take up to 30 minutes before non-Power BI items can be created.

https://learn.microsoft.com/en-us/fabric/admin/service-admin-premium-multi-geo?tabs=power-bi-premium

 

This puts you in a tough spot, and I don't have a good answer for how you can proceed.