Remove XML encoding information with PowerShell

[Elenakretova]

I'm currently using TFS PowerTools to run a query in PowerShell and export the results as an XML file. I then want to import that XML file into Alteryx for further processing. When TFS PT exports the XML file it puts the following header at the top:

<?xml version="1.0" encoding="utf-8"?>

However Alteryx does not like this and refuses to read the document unless the encoding information is taken off. Is there a way that I can use PowerShell to remove the encoding information so it only shows:

[v-yulgu-msft]

Hi @Elenakretova,

Welcome to Power BI desktop forum. As this forum provides support for Power BI, your question is more related to TFS PowerTools, I would suggest you post your questions on TFS forum to get more professional advice.

Regards,

Yuliana Gu