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

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
dhorrall
Frequent Visitor

Dataflow (Gen2): Specifying target table schema if is a new table

I tried to create a new table in a target Warehouse.

When I tried to create a new table with tst.theTable, 

dhorrall_1-1685046922309.png

 

I ended up with:

dhorrall_2-1685047007059.png

It seems to use the schema from the 'source' table I was extracting from (which was 'coupa')

I see no place to specifiy the target schema explicitly other than what I tried with 'dot' notation in the table name field.

 

Putting aside the fact that I am writing to a Fabric Warehouse, even though I chose Azure SQL Server as the target.  This seems like a bug.

 

 

6 REPLIES 6
Pfisterbi
Advocate I
Advocate I

Run into the same issue.

We need a possibility to choose a schema.

Yeah, I think so, too...
SidJay
Microsoft
Microsoft

There isn't currently a way to customize the schema. We are tracking this as a feature gap.

What is the status of this, is there a chance to track this?

miguel
Community Admin
Community Admin

Thank you for the feedback! I went ahead and forwarded this information to the appropriate internal team so they can take a look at this thread.

Hi Miguel @miguel 

 

Any news on this?

Helpful resources

Announcements
November Fabric 2023 Webinars

Fabric Monthly Update - November 2023

Check out the November 2023 Fabric update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.