Excel Data changes on refresh

[AB1977]

Hi, I have an excel spreadheet that sits on my one drive and is linked to a report on the Power BI service.

The spreadsheet is a report download from 3rd party software that I use. I download daily, and save over the top of the existing file on my one drive.

One of the columns in the excel data has either a TRUE or FALSE value and I have a calculated column base don these true/false values that then is used to create a visual.

The problem I have is that when the dataet refreshes in the service is changes the TRUE/FALSE values to 0/-1 and therfore my calculated column no longer owrks and the visual fails.

Has anyone come accross this or know why it may be happening?

Many Thanks

[v-jiascu-msft · Accepted solution]

Hi @AB1977,

We could try the way @Anonymous introduced. Open Query Editor, change the data type of that column into “True/False”. Republish to the Service.

 

Best Regards!

Dale

[Anonymous]

Sounds like something to fix in the Power Query import section of Power BI.  Just do a find/replace.