Forum Discussion
Finding Phantom Errors
It's difficult to tell without your code / example data.
Just to illustrate: the following code:
let Source = {1..10}, #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Number"}}), #"Replaced Value" = Table.ReplaceValue(#"Renamed Columns",4,-1/0,Replacer.ReplaceValue,{"Number"}), #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value",8,1/0,Replacer.ReplaceValue,{"Number"}), MyTable = Table.TransformColumnTypes(#"Replaced Value1",{{"Number", type number}}) in MyTableReturns, after loading in Power BI Desktop, without any errors reported:
MarcelBeug - I did do the replace before the type conversion. My goal being that the type conversion would interpret them as whatever the equivalent value is in the decimal number format. Is there a different way I should be doing this? Unless the format doesn't have a representation for infinity at all...that would be annoying, but I could probably do something ugly to get around it.
It's difficult to tell without your code / example data.
Just to illustrate: the following code:
let
Source = {1..10},
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Number"}}),
#"Replaced Value" = Table.ReplaceValue(#"Renamed Columns",4,-1/0,Replacer.ReplaceValue,{"Number"}),
#"Replaced Value1" = Table.ReplaceValue(#"Replaced Value",8,1/0,Replacer.ReplaceValue,{"Number"}),
MyTable = Table.TransformColumnTypes(#"Replaced Value1",{{"Number", type number}})
in
MyTableReturns, after loading in Power BI Desktop, without any errors reported:
MarcelBeug - Ah perfect, this is what I was missing. I was trying to convert the literal text value "Infinity", and it wasn't getting there, but 1/0 is working. Thanks!