Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 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
    8 years ago

    Hi Anonymous,

     

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

     

    Regards,

    Yuliana Gu

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 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
      8 years ago

      Hi Yuliana

       

      The option is greyed out:

       

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

        Hi Anonymous,

         

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

         

        Regards,

        Yuliana Gu