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.
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"
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
You can propigate nulls like:
myTable{2}?[ColumnName]?
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.