Forum Discussion
Post PatronPower Query Editor showing column as TRUE / FALSE but source is showing as 1 or 0
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
4 Replies
veenashenolikarHelper V
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
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.
- PhilipTreacy
Super User
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
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
