int being cast to boolean and incorrectly transformed back to int

[mauropasi]

Hi everybody. 

I am connecting to an MySQL database and I have a column being picked up by Power BI as boolean even though it is int.

I know that this happens because power query is only looking at the first x (200?) rows of data.

What I have always done to fix this is just transforming the type to int but for some reason is doesn't seem to fix it this time. I only get 0s and 1s. It's like it is actually converting the values instead of folding the query correctly and getting them as int in the first place.

If I force the type casting with cast() in the SQL query it works for me but then I introduce a block for following query foldings which I am not sure it is what I want to do.

Is there any way to force power bi to look at more rows or to make sure that the transformation is successful.

[mauropasi]

it may have something to do with the schema being wrong in the first place but I would still like to do something about it.

[mauropasi · Accepted solution]

There is a 

TreatTinyAsBoolean = false

which seems to be what I am looking for. I just need to figure out how to use it and what effects it will have on query folding.

[phiemancraft]

How i can running that code?