cancel
Showing results for 
Search instead for 
Did you mean: 
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.

 

 

3 REPLIES 3
Pfisterbi
Helper I
Helper I

Run into the same issue.

We need a possibility to choose a schema.

SidJay
Microsoft
Microsoft

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

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.

Helpful resources

Announcements
MPPC 2023 Fabric Carousel

Power Platform Conference-Fabric and Power BI Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Fabric August Update Carousel

Fabric August 2023 Update

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

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Data Factory Founders Badge

Data Factory Community Founders Badge

Become a founding member of the Data Factory Community.