Forum Discussion

JacktheYeti's avatar
JacktheYeti
Helper I
6 years ago
Solved

PowerBI Data Types

Hello,   I'm importing data from a mySQL database to run some reports on. There is a column that repsents the coupon type and is identified by a number 1 - 5.   When the data is loaded into Power...
Need Help
  • JacktheYeti's avatar
    JacktheYeti
    6 years ago

    The column causing trouble was type TINYINT inside the database. I created a new datasource and wrote a SQL statement that used the CAST() function to change the type and load it into PowerBI successfully. 

     

    For reference, it looked like this: 

    CAST(coupon.type AS SIGNED) as coupon_Type

     

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi JacktheYeti ,

 

Method 1:

Go to File->Options and settings-> Options, disable the type detection option like picture below (disable the option will affect all fields' type detection, so do this carefully).

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Method 2:

Change the data type in Report view or Data view .

 

 

 

 

 

Method 3:

Enter into Query Editor, delete the step named "Changed Type", or change the data type.

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

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

  • JacktheYeti's avatar
    JacktheYeti
    Helper I
    6 years ago

    Thanks Amy, I gave this a try but was unsuccessful. The data would load in as TRUE and FALSE or 1 and 0.