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 = 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?

 

 

General Comment

3 Replies

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