Forum Discussion
smallint values from sql query shown as data type text
Dear all, I have a power query for a table from MS SQL Server. This table contains a column of type smallint, but the value is shown in Query as type "decimal number". --> Why does PowerBI not d...
Hi Anonymous
Normally it does it automatically, but if it hasn't you can add this step by going to Transform > Detect Data Type or click on the data type on the left of the column and pick the type manually.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
I can report that this still not has been resolved tree year later. Anyone having an ideomatic way to workaround this?