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.
Hi All,
Having an issue when expanding an xml file. For some reason it is detecting some values as a table which are a single values.
I have a cell highlighted in the photo where the value is just "3" but it is displaying as a table. Then later on the same column is displaying correctly. Bit confused. I assume it is a simple fix.
Thanks
Solved! Go to Solution.
Hello @Anonymous
you have to use Table.TransformColumns instead of TransformColumnTypes
BR
Jimmy
Hello @Anonymous
you have to use Table.TransformColumns instead of TransformColumnTypes
BR
Jimmy
Hello @Anonymous
I'm not an expert on XML, but I think if power query is identifying as table, then there is a reason for that in XML. What you can do is to apply a Transform.Columns to read from the table first cell / first column. Here an example of a possible function
{{"Element:Text", each try _[#"Element:Text"]{0} otherwise _}}
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
@Jimmy801
Hi Jimmy, I am struggling to get this to work. I potentially am not doing it correctly.
So say for the Column "Race.Dog.Box" how would would that look
I believe the start would be = Table.TransformColumnTypes(#"Expanded Race.Dog",{{"Race.Dog.Box".........
Sorry, i am lacking experience with this sort of stuff
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.
User | Count |
---|---|
99 | |
50 | |
19 | |
12 | |
11 |