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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors