Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Remove decimals in table when using Direct Query

I have no problem removing decimals using an import.   Is there anyway to do the same thing when usinf direct query instead.
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

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

     

    Regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

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

 

Best regards,

Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Yuliana

     

    The option is greyed out:

     

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft Employee
      7 years ago

      Hi Anonymous,

       

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

       

      Regards,

      Yuliana Gu