how to remove null values from columns having record values

[Anonymous]

I have added expanding record values in data flow, when refresh it is throwing below error. how to remove rows having null value from these two columns 

Error: We cannot convert the value null to type Record... RootActivityId = 4xyz.Param1 = We cannot convert the value null to type Record. Request ID: xyz

[Fowmy]

@Anonymous 

Try to remove the nulls in one of the previous steps and try.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Anonymous]

how do i remove null rows fro column type records

[Fowmy]

@Anonymous 

Can you share your query?

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Anonymous · Accepted solution]

let

  Source =

  ITOVC_TO_LN__c = Source{[Name = "ITOVC_TO_LN__c"]}[Data],

  #"Filtered Rows" = Table.SelectRows(ITOVC_TO_LN__c, each [CreatedDate] >= (Date.EndOfMonth(Date.AddMonths(DateTime.LocalNow(),-6))) and [CreatedDate] < DateTime.LocalNow()),

    #"Filtered rowsnew" = Table.SelectRows(#"Filtered Rows", each [REF_MST_TO_LN_NO__r] <> null and [REF_MST_TO_NO__r] <> "")



is this correct way to remove null or empty? but the operator only gets disabled

[Anonymous]

Hi @Anonymous ,

It is a little difficult to find the root cause based on provided information... Could you please provide your pbix file if it is convenient?

Best Regards

Rena