Forum Discussion

gpiero's avatar
gpiero
Icon for Skilled Sharer rankSkilled Sharer
8 years ago
Solved

How to put a break point/tracing errors during query execution

  I'am facing a strange error message during the stage showed in the image below.   The warning indicates  that a specific column is not in the table. But I think this message is misleading. Is t...
Need Help
  • Maddy99's avatar
    Maddy99
    8 years ago

    then  dont know what it could be from my computer.

    i hope some one else can help. sorry

gpiero's avatar
gpiero
Icon for Skilled Sharer rankSkilled Sharer
8 years ago

Maddy99

I think the sintax is correct. In fact in another query it works in a proper way

 

#"Added Conditional Column" = Table.AddColumn(#"Renamed Columns", "CheckGroupMtrl1", 
                  each if Text.Trim([#"COOIS.FatherGroup"]) <> null
                          and [#"Material  "] <> null
                          and Text.Trim([#"COOIS.FatherGroup"]) = [#"Material  "]
                  then 1
Maddy99's avatar
Maddy99
Icon for Resolver II rankResolver II
8 years ago

then  dont know what it could be from my computer.

i hope some one else can help. sorry

  • gpiero's avatar
    gpiero
    Icon for Skilled Sharer rankSkilled Sharer
    8 years ago

    Maddy99

    Sorry for my delay in closing this post.

    It is not a matter of wrong sintax.

     

    I had a similar problem in a new PBI report. Then we discovered that a certain field of of our ERP contains a variable number of strings.

    It is highlithed by "*" at the end of the field. The I added in the query Split By Characther, creating 25 new columns.

    Issue solved.

    Regards