Import datasource from ODBC --- but can't get decimal numbers

[baron33]

My data source is sqlite 3 database so i create odbc connection.

The tricky thing I found is that one columns of decimal numbers are processed into whole numbers in the table.

I even't can't any place to modify it --- even in advance editor:

let
Source = Odbc.DataSource("dsn=GMDSR Recruitment", [HierarchicalNavigation=true]),
target_Table = Source{[Name="target",Kind="Table"]}[Data]
in
target_Table

As there are only two steps:  source and navigation 

[v-xulin-mstf]

Hi @baron33,

I have not heard from you for a long time, if your issue solved?

Best Regards,

Link

[v-xulin-mstf]

Hi @baron33,

I am not sure about the error.

Could you convert to other data types? Like Currency or Double.

Maybe you can reimport data.

If not work, please details.

Best Regards,

Link

[amitchandak]

@baron33 ,  On the First Tab you have an option to change data type. Change it to decimal and check