DataFormat.Error: We couldn't convert to Number. Details: ‎495450

[Anonymous]

Hello Community, 
I am a Newbie to the Power bi Platform.

I have been working on transform data and facing this issue (below Image) while performing the Inner Join  

My Source has this formula.

= Table.NestedJoin(CompetencyVsTime, {"Id competency", "Job Code"}, Ref, {"CompetencyId", "Job Code"}, "Ref", JoinKind.Inner)

 I have tried seqarching for 495450 in both the tables but was unabke to find the row.

Here are the snapshots of data from the tables that i have joined

Here is the Snapshot of error row: Was unable to delete it.

Please help me with this.

Thanks in Advance 🙂 

[Mahesh0016 · Accepted solution]

@Anonymous can you please check your joing column data type make sure both column data type same.
if it is Any data type please convert in text data type.THANK YOU!!

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

By my research and test, the step Table.SelectRows(#"previous step", each true) will return all the rows, so I guess in your sample "Filtered Rows" is not the first step returning error, please find the first error step and click to see the error details.

According to your description, you merged CompetencyVsTime table and Ref table getting the "Final" table, then you want to delete rows with error. If so, you can directly click Remove Rows>Remove Errors.

Best regards,

Community Support Team_yanjiang

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

[Mahesh0016 · Accepted solution]

@Anonymous can you please check your joing column data type make sure both column data type same.
if it is Any data type please convert in text data type.THANK YOU!!