Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I plan to import a folder containing XML-Files - I´d like to have one row per file.
However I even fail to import a single XML-file.
In all tutorials I´ve seen on YouTube a Navigator-window appears which should look something like this:
However when I try to import the XML-file in Power BI only this appears:
I already have seen in another thread that it might help to click on the gear in Source and to change File origin to "1252: Western European (Windows)" (I am located in Germany and I work on Windows).
But this did not help.
Here is the complete XML:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE Tool-Data SYSTEM "DIN_4000_Schema.dtd">
<Tool-Data>
<TimeStamp>22.06.2018 08:48:07</TimeStamp>
<Tool>
<Main-Data>
<Manufacturer></Manufacturer>
<Supplier></Supplier>
<ID21002 Desc_DE="Kundensachnummer">12345</ID21002>
</Main-Data>
<Category>
<Category-Data>
<Source>DIN</Source>
<Level>1</Level>
<PropertyName Source="din_mk">NSM</PropertyName>
<Value>DIN4000-81</Value>
</Category-Data>
<Category-Data>
<Source>DIN</Source>
<Level>2</Level>
<PropertyName Source="din_mk">BLD</PropertyName>
<Value>1</Value>
</Category-Data>
</Category>
<Properties>
<Property-Data>
<PropertyName Source="din_mk">J22</PropertyName>
<Value>30-1000-0050</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">A11</PropertyName>
<Value> 0.500</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">B3</PropertyName>
<Value> 5.500</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">B4</PropertyName>
<Value> 4.500</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">B5</PropertyName>
<Value> 30.000</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">B71</PropertyName>
<Value> 29.856</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">C11</PropertyName>
<Value>ZYL</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">C12</PropertyName>
<Value>01</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">C2</PropertyName>
<Value>0005</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">C3</PropertyName>
<Value> 0.500</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">D1</PropertyName>
<Value>2</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">D7</PropertyName>
<Value> 0.000</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">E1</PropertyName>
<Value>120.000000</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">F1</PropertyName>
<Value>R</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">G2</PropertyName>
<Value>0</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">H22</PropertyName>
<Value>0</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">B6</PropertyName>
<Value> 5.500</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">B7</PropertyName>
<Value> 0.144</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">C32</PropertyName>
<Value> 0.000</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">C33</PropertyName>
<Value> 0.000</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">C4</PropertyName>
<Value> 24.500</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">D2</PropertyName>
<Value>R</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">D3</PropertyName>
<Value> 30.000000</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">D4</PropertyName>
<Value> 2.721</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">D6</PropertyName>
<Value>0</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">G5</PropertyName>
<Value>0</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">H21</PropertyName>
<Value>0</Value>
</Property-Data>
<Property-Data>
<PropertyName Source="din_mk">J7</PropertyName>
<Value>0</Value>
</Property-Data>
</Properties>
</Tool>
</Tool-Data>
I there something wrong with the XML or is there anything else I can do?
Thank you!
Solved! Go to Solution.
Hi @cosmicyes
Thanks for reaching out to us.
Since its attribute is table, it does not have "transform" option, you need to click the extend button first
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @cosmicyes
Thanks for reaching out to us.
Since its attribute is table, it does not have "transform" option, you need to click the extend button first
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Thank you.
This helps me a lot.
@amitchandak
Thank you for your quick response.
I have tried but my menu looks different than yours and there is no transform
Any idea?
@cosmicyes , Right click on the second column and under transform mark it as XML, then you should get an option to expand
User | Count |
---|---|
131 | |
74 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |