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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Yizi
New Member

Fabric Dataflow Gen2 Destination Schema

Hi Chaps, I'm not sure if this has been answered, but I did some digging and couldn't find anything. 

 

I have Gen2 Dataflow in Fabric, which picks a warehouse as the destination. I've created 3 schemas, and I like the data to be placed in the schema of my choice; however, this is not the behaviour as it places the files automatically in the dbo schema. I do not see any options for this, and manually moving the table to another schema is not ideal.

 

My 3 schemas:

- Bronze <-- this is where I like to drop the files from dataflows

- Silver

- Gold

 

Any ideas? 

1 REPLY 1
Yizi
New Member

There is a shortcut I managed to figure out, and it does the job. If you create the table under the new schema, you can change the destination and select the existing table under the correct schema. 

 

Ideally this option should be available under the wizard but I understand the app is still in beta mode.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors