Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
stewartfiserv
Frequent Visitor

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(AddedPrimaryKey, {{"Parent Id", each if _ <> null then Number.FromText(Text.End(_, Text.Length(_)-2)) else null, Int32.Type}})

 

The resulting table shows that the Parent Id field has null values.  You can see them.  

 

However, when I try to filter records where [Parent Id] = null, I do not get any matches.  It's as if the null value retruned by Transform Columns is not a normal null value.  If I run the same filter prior to this step if finds records. 

 

Any idea what I am doing wrong in this step?  Is this really a bug?

1 REPLY 1
stewartfiserv
Frequent Visitor

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?

 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors