App.power.bi is changing my true/false column to -1,0 after being uploaded for awhile

[ELIN237]

Hi All--I'm having a weird problem where a true/false column is fine immediately after being uploaded to app.power.bi, but then after awhile, it is converting to -1,0.  Has anyone else experienced this or have any suggestions on how to fix it?  I wouldn't care if it wasn't messing up some conditional formatting and filters.  TIA.

[collinq]

Hey @ELIN237 ,

The first answer is that you should create a ticket to get Microsoft help on this.  (Support | Microsoft Power BI and select the "Get Support").

The second answer is that I have had this happen to me enough times that I just create a "1 or 0"  or even a text field that is "Yes, No" in the file itself and use that.  I know, that is treating the symptom and not the cause but I gave up the fight some time ago.  

[ELIN237 · Accepted solution]

I figured out a solution...I just rewrote everything to account for the eventual conversion....