Solved: Re: Remove decimals in table when using Direct Que...

Anonymous · ‎08-30-2018

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 · ‎09-03-2018

Hi @Anonymous,

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

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-yulgu-msft · ‎08-30-2018

Hi @Anonymous,

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

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎08-31-2018

Hi Yuliana

The option is greyed out:

v-yulgu-msft · ‎09-03-2018

Hi @Anonymous,

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

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.