Forum Discussion
Helper IIIncorrect Data type in power BI desktop
Hi
I am connecting the MySQL database to the power bi desktop through the power query editor and the entire DB is connected without any issue but the table I am working on has a column in INT data type which has some integer values between 1 to 5 but in power bi, it shows as boolean value with values as TRUE and FALSE only.
What's the issue here.
Thank you in advance
Romal
4 Replies
- v-janeyg-msft
Community Support
Hi, romals29
Do you modify it in power query? If you simply change the changed data type back, you may have lost the original data, you need to go to power query and check whether the data in that column is normal in the first step of obtaining the data source. If it is displayed as any, change it to number. If you already have other steps that may be affected, you need to modify them together.
Best Regards,
Community Support Team _ Janey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. - ribisht17
Super User
Hi Romal,
Difficult to say without data set although you can change from Boolean to INT again there Change data type in Power BI - MSBI Docs
Regards,
Ritesh
Please mark the answer if it helps you so that it can help others as well
romals29Hi Ritesh
Yes, I did it but then I can see only 1 & 0 .. This is not serve the purpose. I dont understand how the column value shows correctly in my mysql workbench but totally different in power BI
- ribisht17
Your case is quite similar to this one Solved: int being cast to boolean and incorrectly transfor... - Microsoft Power BI Community
Hope it helps!!
Ritesh
