Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
I'm trying to access TEXT data in an XML file. I can get the Attributes fine, but not the text!
The XML file is in format below and I can access the ActionRow data (ID/BID/XYX) ok by expanding the table, but I also need the MAINID value (2888 in this example), but can't figure out how to get it!
Any help appreciated.
Wayne
<XMLFEED>
<MAINID>2888
<Data>
<ActionRow ID="123" BID="321" XYX="999"/>
<ActionRow ID="124" BID="333" XYX="888"/>
</Data>
</MAINID>
</XMLFEED>
Try this custom Column
Change the file name and address in red font below
=Text.BeforeDelimiter( Xml.Document(File.Contents("C:\Users\hp\Desktop\File.xml"))[Value]{0}[Value]{0}, " ")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |