Power Query Editor showing column as TRUE / FALSE but source is showing as 1 or 0

[AvPowerBI]

Hi,

I am connecting to an Azure SQL Database and the View I am selecting has a column where the values are 1 or 0, when this is imported into Power BI Desktip and I view this in Power Query Editor the value is showing this TRUE or FALSE. Why is this, I have added a Custom column after this and it is not returning the correct results be it is looking for a 1 which is nver there. How do I just show it as 1 or 0 only?

Thanks

[Anonymous]

Hi @AvPowerBI ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Stephen Tao

[PhilipTreacy]

Hi @AvPowerBI 

If thee source column is 1's and 0's then someething in your PQ code is changing that to true/false.  Checks the query steps to see what - look for stpes with names like Changed Type

Alternatively, chnage the type of the True/False column to Whole Number 

Regards

Phil

[Anonymous]

Hi @AvPowerBI ,

Are your results in logical(1/0)? If they are, try to change data type to True/False. 

 

Otherwise, you could try to create a conditional column, then change the data type of the new column to True/False.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[veenashenolikar]

Hi @AvPowerBI 

Did you try changing the data type to "Whole Number". It automatically converts it to 0 and 1

If I helped you solve your problem, please mark this as a solution!

Regards,

Veena Shenolikar