Forum Discussion
Helper ISave data in fabric datawarehouse custom schema table
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.
5 Replies
- puneetvijwani
Resolver IV
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 SchemaPS: If my response helped, kindly select it as the solution. Your kudos are greatly appreciated!
Arnab0111I 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
- 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 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
