Fabric Rest API Partition Loss when Overwriting CSV Table

[akanane]

Hello everyone,

I've encountered an issue while using the Fabric REST API to load a CSV file into a table in overwrite mode. 

Here's an outline of the steps I've followed:

1. Created a table with column partitions
2. Load data from a CSV file into this table in overwrite mode using the api

After performing the data load operation via the API in overwrite mode, the table appears to lose its partitioning. I've verified the table setup, but the partitions seem to vanish after the data load.

Any insights, suggestions, or alternative approaches to preserve partitions during the overwrite data load process would be greatly appreciated.

Thank you in advance for your help and insights!

Best regards

Amnay

[v-gchenna-msft]

Hello @akanane .

Thanks for using Fabric Community.

At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.

[v-gchenna-msft]

Hi @akanane ,

Apologies for the issue you have been facing. If its a bug, we will definitely would like to know and properly address it. 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.

[v-gchenna-msft]

Hi @akanane ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond back with the more details and we will try to help .

[v-gchenna-msft]

Hi @akanane ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond back with the more details and we will try to help .