PowerBI wrongly changing "0" and "1" to just "1"

[MichaelPercival]

Hiya, 

Totally bambuzled by an apparent PowerBI glitch.

I've got an excel table that calculates either a 1 or a 0. A powerquery to the spreadsheet then adds this to PowerBI. In PowerQuery the numbers match excel. When it enters PowerBI however, it switches everything to 1. I've tried changing the data type in Power Query and PowerBI to see if that's affecting the resul, but whether as True/False, Text, number, or decimal, it always shows correctly in PowerQuery, but incorrectly in Power BI.

I appreciate the below isn't very useful for diagnostics, but hoping someone might have come across this issue before/known issue?

Data in PowerQuery:

Same rows in PowerBI:

[MichaelPercival]

To answer the above, that's what has me stumped - there's no real processing in Powerquery, and as mentioned, I've tried changing the data type in Powerquery to true/false, number, text, and decimal and always shows correcy in Power Query.

and I'm looking at the table view in Powerbi, and trying all the data types to see if I can get it to display anything different, but always each row that shows 0 in both Excel/PowerBI is changed to 1 in PowerBI table,(or true if set to true/false).

[v-tianyich-msft]

Hi @MichaelPercival ,

Please check if enable load is enabled for this table in the power query and the steps are applied.

Best regards,
Community Support Team_ Scott Chang

[ajohnso2]

Just a thought to ensure your PBI visual is not doing some kind of aggregation also. I.e Max, Min, Sum etc.

Posting your model may help, do you have any joins to other tables that could effect the outcome?

Not come across this as an issue/bug myself...

[audreygerred]

What steps do you have applied in Power Query?