Forum Discussion

Dadii's avatar
Dadii
Regular Visitor
4 years ago

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

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 = Pipeli...
General Comment
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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's avatar
Dadii
Regular Visitor
4 years ago

 

Dear Ibendlin

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

Thanks

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    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.