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
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
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.