Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Patron
Post Patron

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



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?



Community Support
Community Support

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


Super User
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 




Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin

Proud to be a Super User!

Community Support
Community Support

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.


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!



Veena Shenolikar

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.