Issue with True/False

[Anonymous]

Hello all, 

I have imported a new db on BI and i am trying to use column X from table A. Column X contains values 0,1,2,3,4,5 but inside BI the content changes to TRUE/FALSE. I go to the "Model" view and see that the type is selected as True/False and i change it to Text, and i get the same result. If i try to change the data type to Whole Number, then the change does not go through.

On the original table the type of the field is tinyint(1), in case it helps. ( I am updating original post as I go) . 

I have now found that I am looking for such a setting: "TreatTinyAsBoolean = false"

Do you have any suggestions?

Best, 

Zisis

[v-xicai]

Hi  @Anonymous ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case.

Best regards

Amy Cai

[ai_gg1n]

Hi @v-xicai !

I have same issue as @Anonymous, tried all your steps and this doesn't help. Any idea?

Best regards,

Dmitriy

[v-xicai]

Hi zisis,

From your description, it seems that the data type for the column defined in database is tinyint(1), after importing data to power BI desktop, the column data type is changed to True/False and can’t be changed to Whole Number, right?

Please change the Power BI Desktop setting before loading data showing picture below by click File-> Options and settings-> Options, then refresh the report or reimport the data.

If the issue still occurs, please go to Query Editor, check the Applied Steps pane, find if there is any step to change the data type. If there is, please remove it or add another step to change the data type to Whole Number in Query Editor, then apply the change.

Best Regards,

Amy

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