Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Issue with True/False

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" ...
Need Help
v-xicai's avatar
v-xicai
Community Support
7 years ago

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.