Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Logical type in data source

Hi!

 

Does anyone know how to force a variable to enter as logical (True/False) on data load?

 

Thanks!

 

 

Need Help

3 Replies

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    You can set the datatype of a column in Power Query.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks for the reply, I mean that the variable already enters with that type without having to change it.

       

      Thanks.

      • johnt75's avatar
        johnt75
        Super User
        3 years ago

        That would depend on your source, but I think if it returns true and false as text values, rather than 1 and 0 for example, it should get picked up automatically.