Power BI automatically converts 1 to -1

[DerekMcKinnon]

Sorry, I'm a newbie to Power BI.  The first screenshot below is a simple query of my MySQL data showing just one row.  You can see the Booked, Present and Charged fields are all 1.

Below is a screenshot from my Power BI data table.  The same data is included, but now the values are all -1.

Several days ago when I first imported the data it was importing as true and false, so I changed the data type and it worked fine.  Today I fixed up some of the joins between data sources and updated the data, and then it started coming in as negative.

What have I missed?

Thanks

Derek

[DerekMcKinnon]

There was no specific change type in query originally, but once I applied the data type change it all started working.

[v-xiaotang · Accepted solution]

Hi @DerekMcKinnon 

It seems that this is due to the change of data type. Please go to Power Query, remove the step Changed Type, then change the column type again.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@DerekMcKinnon , This can be a data type conversion issue. Try doing this change of data type in power query and try