Forum Discussion

RP_OFaustino's avatar
RP_OFaustino
Helper I
2 years ago
Solved

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

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 i...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

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's avatar
RP_OFaustino
Helper I
2 years ago

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!