PowerBI is incrementing my data after loading?

Hi,

I am using direct query mode to grab data from sql server. The data before bringing into power bi shows the correct value.

However, wherever I used the variable all the values show up as 1 above what it should be? Is this a bug/is there a fix for this issue? The data is stored as big int in sql server.

Data preview before bringing in dataAfter data has been loaded