We cannot convert the value null to type Logical (M scrip)

[Dadii]

Kindly help me! 

I found dataflow running "Failed" 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.

I have none skill M scrip. Which line Error?

[lbendlin]

Start from the back of the query. Eliminate steps one by one until the error is no longer raised. (make sure to back up the query before this).

If you have no M skills yet you may want to start with (much) simpler queries.

[Dadii]

Dear Ibendlin

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

Thanks

[lbendlin]

Learn about Value.Is() , Type.Is(), and the "try ... otherwise ... "  construct.  Note that all these require manual typing.  If you are new to Power Query then you may want to ask someone in your team with more experience to help you.