No XML option on Lakehouse destination

[DanielAmbler]

Hi,

I have a requirement to connect to a third party 'API' that spits out XML only.

I notice I dont have the option to save XML to a Lakehouse Destination via a Copy Activity.  Documentation specifies XML should be supported (Configure Lakehouse in a copy activity - Microsoft Fabric | Microsoft Learn)

Have tried creating a brand new Copy activity explicitly setup with an XML file format so I could rule out any other setup causing this.

[DanielAmbler · Accepted solution]

I currently have a support ticket raised but for now here is a workaround I have developed Microsoft Fabric - Ingest XML into Lakehouse - Dan Ambler

[v-cboorla-msft]

Hi @DanielAmbler 

Glad that you were able to find some insights and thank you for sharing the same with the community as it can be helpful to others.
Please continue using Fabric Community for further queries.

Thank you.

[DanielAmbler]

Thank you - I also raised support ticket 2406140050001979 for this as its critical to my POC.

[DanielAmbler]

Also tried connecting directly to ADLS Gen 2 with the same result.

[v-cboorla-msft]

Hi @DanielAmbler 

Apologies for the issue you are facing.
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.
Appreciate your patience.

Thanks.