Forum Discussion

hrgm's avatar
hrgm
Frequent Visitor
3 years ago

Data Conversion Issue from MySQL to Power BI: Displaying Incorrect Values

Hello everyone, I hope you're all doing well. I'm currently facing challenges while trying to load data from MySQL. The data columns in MySQL are of type Tinyint(1), containing values ranging from ...
Need Help
danextian's avatar
danextian
Super User
2 years ago

Hi hrgm ,

 

I think I understand what happened. Power Query automatically changed the data type for that column to logical/boolean but, because it was the wrong type, you changed it to integer. If you add another step instead of modifying the first changed type step, you'll end up with either 1 or 0.  If this is the case, go to Power Query and then to the applied step that changed the data type to logical. In t he formula bar, find the column name and replace the type from type logical to Int64.Type (case-sensitive) similar to the screeenshot below.

 

hrgm's avatar
hrgm
Frequent Visitor
2 years ago

Thank you very much for your assistance.

I tried converting to integer right after the NAVIGATION step because I was converting after advancing through the steps. However, it only resulted in 0 or 1.

By the way, I have also tried other options like text or those not present in the choices like Int32.Type, following internet information, but the issue hasn't improved.

Actual Query:

let Source = MySQL.Database("local***", "INPUT_***", [ReturnSingleDatabase=true]), INPUT_***data = Source{[Schema="INPUT_***",Item="***data"]}[Data],

ChangedType2 = Table.TransformColumnTypes(INPUT_***data,{{"***_flg", Int64.Type}}), FilteredRows2 = Table.SelectRows(ChangedType2, each true),

 

　・・・・Names have been transformed. 

Are there any other possibilities? Thank you for your help.