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
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