Simple web query that errors when loaded to data model in Excel

[masplin]

This query looks fine in query editor and can be loaded connection only, but if i try to add to the data model  I get "[Expression.error] We cannot convert the value null to type list"

I have no idea what this means and makes no sense if it looksok in query window. Can anyone help?

Thanks

let
    Source = Web.Page(Web.Contents("https://tools.morningstar.co.uk/uk/cefreport/default.aspx?SecurityToken=E0GBR01OFV]2]0]FCGBR$$ALL")),
    Data15 = Source{15}[Data],
    Children = Data15{0}[Children],
    Children1 = Children{1}[Children],
    Children2 = Children1{11}[Children],
    Children3 = Children2{1}[Children],
    Children4 = Children3{2}[Children],
    Children5 = Children4{4}[Children],
    Children6 = Children5{1}[Children],
    Children7 = Children6{0}[Children],
    Children8 = Children7{0}[Children],
    Children9 = Children8{1}[Children],
    Children10 = Children9{0}[Children],
    Children11 = Children10{0}[Children],
    Children12 = Children11{0}[Children],
    #"Removed Other Columns" = Table.SelectColumns(Children12,{"Text"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns",{{"Text", "Name"}}),
    #"Added Index" = Table.AddIndexColumn(#"Renamed Columns", "Index", 1, 1)
in
    #"Added Index"

[Greg_Deckler]

I tested this out, pretty sure it means that you are navigating to a child node that doesn't exist.

[masplin]

Ah so if i'm using a function to work on a list and every element in the list doesn't have identical strcture (I assumed a website would have) it can run into a blind alley. If say some pages go down onechild route and other go down a differnet route is it possilbe to use try/otherwise but specify a whole bunch of steps for each option?  I've only ever used try/otherwise for single values

Thanks

Mike

[artemus]

You can propigate nulls like:

myTable{2}?[ColumnName]?