cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

how to remove null values from columns having record values


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

 

 

sanjusanj21_0-1596451082517.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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
 
sanjusanj21_0-1596466942467.png

 

View solution in original post

5 REPLIES 5
Fowmy
Super User
Super User

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

how do i remove null rows fro column type records

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

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
 
sanjusanj21_0-1596466942467.png

 

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors