Forum Discussion

AnisAnalyst's avatar
AnisAnalyst
Frequent Visitor
9 years ago
Solved

cannot Upload XML!

Dear community memebers,

I have been trying to upload an XML file into Power BI, that the data does not display (only the column headers). I tried this on another application and it worked. Can you help me please?

Thanks

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    AnisAnalyst,

    I make a test using this sample XML file, everything works well when I connect to this XML file to the latest version of Power BI Desktop(2.47.4766.542). Would you mind sharing me your XML file so that I can test?

    Regards,
    Lydia

    • AnisAnalyst's avatar
      AnisAnalyst
      Frequent Visitor
      9 years ago

      Thanks Lydia.

      Here is the XML file I have been trying to open in Power BI but without success. 

       

       

      https://1drv.ms/u/s!Ai_AaGbGZf0basPYf4ME0waF8Rs

       

      If you look at the XML data you ll realise it has many column fields, but it only shows one field once opened.

       

      Please help me to open this to display all fileds.

       

      Anis

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        AnisAnalyst,

        After connecting to your XML file in the latest version of Power BI Desktop, I get the following data format in Query Editor of Power BI Desktop. You would need to expand the Header and Body columns to get detailed data.


        Regards,