I think this is a bug.
The query for the table giving the error is :
let
Source = Xml.Tables(Web.Contents(https://server,[Content=Text.ToBinary("<?xml version='1.0' encoding='UTF-8'?><call method=''><credentials login='' password=''></credentials></call>")])),
output = Source{0}[output],
levels = output{0}[levels],
level = levels{0}[level],
ChangedType = Table.TransformColumnTypes(level,{{"Attribute:id", type number}, {"Attribute:name", type text}, {"Attribute:currency", type text}, {"Attribute:abbr", type text}}),
level1 = ChangedType{0}[level],
ChangedType1 = Table.TransformColumnTypes(level1,{{"Attribute:id", type number}, {"Attribute:name", type text}, {"Attribute:currency", type text}, {"Attribute:abbr", type text}}),
level2 = ChangedType1{0}[level],
ChangedType2 = Table.TransformColumnTypes(level2,{{"Attribute:id", type number}, {"Attribute:name", type text}, {"Attribute:currency", type text}, {"Attribute:abbr", type text}}),
level3 = ChangedType2{1}[level],
ChangedType3 = Table.TransformColumnTypes(level3,{{"Attribute:id", type text}, {"Attribute:name", type text}, {"Attribute:currency", type text}, {"Attribute:abbr", type text}}),
#"Attribute:id" = ChangedType3{3}[#"Attribute:id"]
in
#"Attribute:id"
If I amend the ChangedType3 variable by changing {"Attribute:id", type text} to {"Attribute:id", type table} I get an error saying table not recognised, this was just a guess.
When I step back to the previous view the levels are displayed with no error, the tables are displayed with the navigation link and the single levels are displayed as an attribute. I can click through the jagged levels succesfully.
Very odd.
If start the query from the top and drill down through the levels the tables at level 3 are displayed as Error. This only seems to happen when there are single level nodes at the same level as multi-level nodes.
I appreciate this is pre-production software so I'm not too distressed by this.
