Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

PowerBI is Converting TRUE / FALSE to -1/0 on publish

I have a table in a report that contains the following column:-

EscSwitch = SWITCH ( 'RISK_TABLE'[ESCALATE], "TRUE", "YES", "FALSE", "NO" ) where the source data is either TRUE, FALSE or null.
Adding this column to a table in PowerBI desktop works as expected, the column is populate with YES, NO or some blanks. However, when i publish, this column works initially, then when the page is refreshed or re-opoened, the fild then shows just blanks.
To investigate i have added the RISK_TABLE'[ESCALATE] field to the table. This returns -1 or 0 instead of TRUE or FALSE as contained in the source data.
Why is the service changing TRUE / FALSE to -1/0 on publish?
Screenshots below
Not applicable

I encountered the exact same scenario.  My published reports would look fine if I refreshed data using desktop version and then published online.  However, if dataset is refreshed online (manually or scheduled), then the visuals returned with Blank results.  Here's my solution that seems to be working.  Using desktop version,

  1. In Power Query, change the column type to True/False (see screenshot below).
  2. Close and apply.
  3. In each visual, remove any existing use of the original column and replace it with the revised column.
    1. Not sure why I had to do this, but I did.
  4. Save and publish.
  5. Look at report online and it looks fine now.
    1. I tested by refreshing dataset again, but using PowerBI online.
    2. Reports look fine still.

I can't explain why PowerBI is converting the values (doesn't make sense to me!) and I can't explain why my solution is working either, but it is.  I'm going back to my other datasets and applying this solution.  From now on, I will edit all columns containing True/False to use the True/False column type.  Hope this helps!



Frequent Visitor

Any resolution to this? I'm having this problem and it's breaking my reports daily. There was no issue for about a month and it started all of a sudden.

Not applicable

Checkout my reply posted today... I think it fixed my issue.

Solution Sage
Solution Sage

This issue still persists in service and is not fixed 

Community Support
Community Support

Hi @Anonymous ,


Sorry for that, but we cannot reproduce your issue on my side, What is the kind of connection you are using, import or directquery?2.jpg3.jpg4.jpg5.jpg6.jpg


Best regards,


Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not applicable

Hi, this is Microsofr Project Online data accessed by odata.

URL used is

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors