We cannot convert the value null to type Logical

[Dadii]

Kindly help me!

Error: PipelineException: We cannot convert the value null to type Logical. . RootActivityId = 575cdb0d-3058-404f-adb9-0e0f0393c4d6.Param1 = PipelineException: We cannot convert the value null to type Logical. Request ID: 0c63b0e7-f532-4f93-bcc1-1e166c8f99ab.

Which line Error and How solve?

[Vijay_A_Verma]

In your Applied steps screen, please click on steps one by one starting with first. Then on one step, you will receive this error.

Post the code of that step from Advanced Editor.

[Dadii]

Dear Vijay,  

I think that this table is cannot convert the value null to type Logical. Kindly advise to solve on Power query online.

Thanks

[Anonymous · Accepted solution]

Hi @Dadii ,

It works fine on my device. 

The added conditional column can be logical type.

Best Regards,

Stephen Tao

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

[Dadii]

Do you think, this picture are Error: PipelineException: We cannot convert the value null to type Logical. . RootActivityId = 6011c63f-abaa-4d2c-a633-140a1f41aee2.Param1 = PipelineException: We cannot convert the value null to type Logical. Request ID: 8257d137-1245-44fa-a23b-e145498c2186. ?????