Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
DiKi-I
Post Patron
Post Patron

Generate data script from ssms for fabric warehouse

is it possible to generate data script for warehouse tables? I need to export the data to another tenant,

1 ACCEPTED SOLUTION
v-saisrao-msft
Community Support
Community Support

Hi @DiKi-I,

Thank you for reaching out to the Microsoft Fabric Forum Community. 

As of now, Fabric Warehouse does not support generating data scripts. A recommended approach is to create two Azure service principles, grant them access to the respective workspaces, and use ADF pipelines with Copy Data activities to move data from one tenant to another. 

Below is the link for your reference: 
Solved: Re: MS Fabric migration between tenants - Microsoft Fabric Community 

 

If this post helps, then please consider Accept it as a solution to help the other members find it more quickly.

 

Thank you. 

View solution in original post

9 REPLIES 9
v-saisrao-msft
Community Support
Community Support

Hi @DiKi-I,

We haven’t heard back from you in a while. If your issue has been resolved, please mark the relevant response as the solution to help fellow community members.
If you still need support, Please let us know if you still need assistance.

 

Thank you.

v-saisrao-msft
Community Support
Community Support

Hi @DiKi-I,

I hope you had a chance to review the solution shared earlier. If it addressed your question, please consider accepting it as the solution — it helps others find answers more quickly.
If you're still facing the issue, feel free to reply, and we’ll be happy to assist further.

 

Thank you.

v-saisrao-msft
Community Support
Community Support

Hi @DiKi-I,

I hope you had a chance to review the solution shared earlier. If it addressed your question, please consider accepting it as the solution — it helps others find answers more quickly.
If you're still facing the issue, feel free to reply, and we’ll be happy to assist further.

 

Thank you.

v-saisrao-msft
Community Support
Community Support

Hi @DiKi-I,

Thank you for reaching out to the Microsoft Fabric Forum Community. 

As of now, Fabric Warehouse does not support generating data scripts. A recommended approach is to create two Azure service principles, grant them access to the respective workspaces, and use ADF pipelines with Copy Data activities to move data from one tenant to another. 

Below is the link for your reference: 
Solved: Re: MS Fabric migration between tenants - Microsoft Fabric Community 

 

If this post helps, then please consider Accept it as a solution to help the other members find it more quickly.

 

Thank you. 

DiKi-I
Post Patron
Post Patron

I have to migrate the data from fabric warehouse to another fabric warehouse in different tenant. 

Hey @DiKi-I ,

I do not believe there is a tenant to tenant for Fabric.  You might want to ask in the Database or Fabric forums as this one is for Power BI related questions.  To my knowledge, you have to export to notepad or whatever tool you want from Tenant one and then go to Tenant two and import from your tool.  So, it is a manual process.  BUt, again, maybe in the other forums they know something else.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




This question is more related to fabric. That's why I have posted this in Fabric community.

Hi @DiKi-I ,

Yes, I know that it can get confusing about which forum is which.  This is the Power BI forum (which is part of Fabric) but I think you will get a better response in the forums dedicated to Fabric.  These are the two I am referring to:

collinq_0-1750269741094.png

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




collinq
Super User
Super User

Hi @DiKi-I ,

I think that this question is a bit more about the SQL piece than the Power BI piece.  But, in SQL you can do the "select * into target" funtion.  Or, you could use Dataflows or Notebooks to grab the SQL and put it into Power BI Fabric.  Depending on complexity, you can also just copy the SQL from SSMS and put it into the Advanced section of the Data Source to SQL.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.