Forum Discussion
Overwrite a table with different schema in Dataflow Gen2
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:
You should be able to see the option. The screenshot I gave you was from existing table. From transform environment.
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?
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.
Hi amaaiia
I'm following up on my previous inquiry to see if you've had a chance to create a support ticket for this issue. If a ticket has been created, I would appreciate it if you could provide the ticket number for our reference. This will allow us to track the progress of the issue.
Thanks.
Hi again,
I was facing the same issue today so I removed data destination, removed previous table from the lakehouse and added the data destination again and it was all good. Let's try it out and see if this works.
