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