Forum Discussion
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...
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
When you look at the data in Power Query, you should be able to edit or delete the step that wrongly identifies the column as a bool.
It happens upon initial data load, so it seems there is no step to delete or change. I've tried changing it post load but the BOOL becomes a 1 or 0 when I change it to a whole number type.