Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

XML Expanding Error

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

 

 

xmlerror.PNG

 

 

1 ACCEPTED SOLUTION
Jimmy801
Community Champion
Community Champion

Hello @Anonymous 

 

you have to use Table.TransformColumns instead of TransformColumnTypes

 

BR

 

Jimmy

View solution in original post

3 REPLIES 3
Jimmy801
Community Champion
Community Champion

Hello @Anonymous 

 

you have to use Table.TransformColumns instead of TransformColumnTypes

 

BR

 

Jimmy

Jimmy801
Community Champion
Community Champion

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

 

Anonymous
Not applicable

@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


Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors