Save data in fabric datawarehouse custom schema table

[Arnab0111]

I have a warehouse, under which I created a schema named hr. In dataflow I want to save the result in warehouse as a table under the hr schema but unable to see the option , instead it is getting saved as table under the same warehouse in the default schema of dbo. 

[puneetvijwani]

@Arnab0111  Do you see them also in Query view ?? you can choose to remove this columns in transformation as you do not need them in destination table

[puneetvijwani]

@Arnab0111  For that Would it be possible for you to share some additional details on how you've configured your dataflows and established table relationships? 

[Arnab0111]

The above is the relationships created among 4 tables in warehouse.

In the above snapshots from dataflow , we can see that there are some extra columns in the table , and the default mapping is none from the dataflow to warehouse, due to which the refresh fails . The snapshot is for 1 table but the extra columns are present for all 4 tables.

[puneetvijwani]

@Arnab0111 I have tried the same and confrim that i am facing the same problem 
i even tried saving Like schema.table name ..did not worked instead it saved the table in dbo as schema.table name
It sound like a bug so you should definately create a support ticket on this .
Workaround:
However for a workaround what i have done is I have taken that scehma.table which was created under dbo scema query it and Save it as The target table under my Custom schema Just to create a table for first time with my desired scehma 
1.

2. Save the table under Custom Schema

3. Next:::  I confirmed that  my target table is created under Custom Schema (nycgreen) for me its nycgreen.table2
               This is my desired target table 

4. In my dataflow gen2 i changed the target destination by choosing Existing table option and redirected my data to my target table under Custom Schema 

PS: If my response helped, kindly select it as the solution. Your kudos are greatly appreciated!

[Arnab0111]

I have done as mentioned above it is working fine for the initial run , but when I am creating relationships among the 4 tables , after this the dataflow refresh is failing as the table is adding the respective relationships as columns which cannot be mapped