Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
cosmicyes
Helper II
Helper II

XML-Import: Navigator not appearing

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:

cosmicyes_0-1661413819532.png

 

However when I try to import the XML-file in Power BI only this appears:

cosmicyes_1-1661413906010.png

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!

 

 

 

1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

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

vxiaotang_0-1661765326774.png

vxiaotang_1-1661765360929.png

result

vxiaotang_2-1661765381706.png

 

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.

View solution in original post

4 REPLIES 4
v-xiaotang
Community Support
Community Support

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

vxiaotang_0-1661765326774.png

vxiaotang_1-1661765360929.png

result

vxiaotang_2-1661765381706.png

 

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.

cosmicyes
Helper II
Helper II

@amitchandak 
Thank you for your quick response.

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

cosmicyes_0-1661415315673.png

Any idea?

amitchandak
Super User
Super User

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

amitchandak_0-1661414656866.png

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.