How to get xml tag attribute value as a column

[likesharad]

Can someone help with below issue:

I'm importing XML file in power BI for reporting. I've tranformed the xml tags in required columns but in one of the XML tag contains multiple attributes as:

<plan key="RBPOC-DNB" enabled="true" type="chain" shortKey="DNB" shortName="Execution Plan - DNB - Arch " name="Test Automation - Trunk - Execution Plan - DNB - Arch ">

How can I get two of these attributes values of this xml tag in additional columns for my report?

[v-yingjl · Accepted solution]

Hi @likesharad ,

Looks like you have missed the ending "</plan>" in the xml file, add it and use xml connector in power bi to get each value of attribute:

<plan key="RBPOC-DNB" enabled="true" type="chain" shortKey="DNB" shortName="Execution Plan - DNB - Arch " name="Test Automation - Trunk - Execution Plan - DNB - Arch "></plan>

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.