Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
You can use Power Query to expand all columns at once. For more details, please review the following blog and similar thread.
https://blog.crossjoin.co.uk/2014/05/21/expanding-all-columns-in-a-table-in-power-query/
https://community.powerbi.com/t5/Desktop/How-to-expand-all-nested-tables-at-once-table-expandtableco...
Regards,
@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
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
@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,
Ans some of them do not replace the "Table" by values?
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
You can use Power Query to expand all columns at once. For more details, please review the following blog and similar thread.
https://blog.crossjoin.co.uk/2014/05/21/expanding-all-columns-in-a-table-in-power-query/
https://community.powerbi.com/t5/Desktop/How-to-expand-all-nested-tables-at-once-table-expandtableco...
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.