Cannot Find Worksheet when uploading a converted XML (XLSX to XML)

[RP_OFaustino]

Hello,

When I convert an xlsx file to XML, I cannot find the worksheet when I upload it to Power Bi.

I usually get this in the navigation pane:

Is there anything that I need to check in the XML code?

Thank you.

[Ritaf1983 · Accepted solution]

Hi @RP_OFaustino 

It seems that you trying to import it as an excel file and not as xml.

Please refer to the linked guide:

https://www.youtube.com/watch?v=uH-4BpjMWUY

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[RP_OFaustino]

Hi Miss @Ritaf1983 , my apologies for my late reply as I was on Sick Leave. I found out that my client was saving an ordinary xlsx to a XML. the table was not defined in the file and I had to map to fields using an XML Map. Once correctly mapped, the tab/sheet that the table is located is now being picked up by power bi XML connector. Thank you for all your help Ma'am!