Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI dataflow null comparison failure

I think I have found a bug in Power BI Dataflows that does not occur in Power BI Desktop.  It has to do with null comparisons.  I have a step in my flow shown below: Table.TransformColumns(Added...
Dataflow
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I was able to fix the issue by splitting the step:

 

 

    TransformedParentId = Table.TransformColumns(AddedPrimaryKey, {{"Parent Id", each if _ = null then _ else Number.FromText(Text.End(_, Text.Length(_)-2))}}),
    ChangedParentIdColumnType = Table.TransformColumnTypes(TransformedParentId, {{"Parent Id", Int64.Type}}),

Is this a bug?