PowerBI is incrementing my data after loading?

[Artemis1254]

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

[Artemis1254 · Accepted solution]

Hmm since I couldn't understand why it was displaying this behavior I went ahead and cast my field as a nchar and it is displaying correctly now