direct query change alone a type of field float to integer.

[nicolas1]

Hello everybody,

In my data base mondodb, i've got several fields with data type float, when i import in power bi , direct query change the type of  fields in integer,it rounds the values, 0.5 becomes 0, 0.7 becomes 1 etc ....., excepting one field who all values are correct, . I'm try to change in decimal, changement it'sok, but  values don't change. Have you got an idea about this?

Thanks

[v-danhe-msft]

Hi @nicolas1,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft]

Hi @nicolas1,

Could you have tried modify the 'Data Type' in the query editor?

If it still could not work after you have applied it, could you please try to modify the format in 'Model ribbon':

If the problem still persists, could you please share the row data file if possible?

Regards,

Daniel He