Forum Discussion
Overwrite a table with different schema in Dataflow Gen2
Hi,
You should be able to change the schema in the destination settings.
This what I get in f64 capacity. In f2 capacity you should be able to refresh your schema.
Hope this helps.
I'm using Premium F64 capacity.
I can see Dynamic Schema option when I create a NEW table, but not for Existing table:
For Existing table I can only see Refresh destination schema option, but is not working, because I click on it and the destination schema keeps the same. My source new schema has one more column, and it's not being added to destination schema:
- rubayatyasmin2 years agoCommunity Champion
You should be able to see the option. The screenshot I gave you was from existing table. From transform environment.
- amaaiia2 years agoSkilled Sharer
rubayatyasmin As you can see here, I'm also in Transform environment, I'm on Exisiting table and I can't select Dynamic Schema.
Why may be this happening?
- v-cboorla-msft2 years agoMicrosoft Employee
Hi amaaiia
Apologize for the inconvenience that you are facing here.
Please reach out to our support team to gain deeper insights and explore potential solutions, If its a bug, we will definitely would like to know and properly address it. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.
Please go ahead and raise a support ticket to reach our support team:
https://support.fabric.microsoft.com/support
After creating a Support ticket please provide the ticket number as it would help us to track for more information.
Thank you.