Remove decimals in table when using Direct Query

[Anonymous]

I have no problem removing decimals using an import.

Is there anyway to do the same thing when usinf direct query instead.

[v-yulgu-msft]

Hi @Anonymous,

It is still available to set data format in Direct Query.

Best regards,

Yuliana Gu

[Anonymous]

Hi Yuliana

The option is greyed out:

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

You should firstly choose the field that you want to format, then, specify the decimal numbers.

Regards,

Yuliana Gu