Skip to main content
cancel
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

Reply
ELIN237
New Member

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

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.

1 ACCEPTED SOLUTION

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

View solution in original post

2 REPLIES 2
collinq
Super User
Super User

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.  




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




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

Helpful resources

Announcements
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.