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 ...
Need Help
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,

AnisAnalyst's avatar
AnisAnalyst
Frequent Visitor
9 years ago

Thanks Lydia,

Once i expand, I get the "Table" in side cells. Once I click on the two arrows and then click ok, the values appear instead of the link"Table". Is there a way to do that for all columns at once.

Thanks

Anis