XML-Import: Navigator not appearing

[cosmicyes]

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!

[v-xiaotang · Accepted 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.

[cosmicyes]

Thank you.
This helps me a lot.

[cosmicyes]

@amitchandak 
Thank you for your quick response.

I have tried but my menu looks different than yours and there is no transform

Any idea?

[amitchandak]

@cosmicyes , Right click on the second column and under transform mark it as XML, then you should get an option to expand