Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Power BI cannot convert to integer from Oracle

Hi, We are trying to bring an integer number from Oracle but the power query always recognize it as decimal number. We already tried use CAST ( #number as INT ) and TO_INT Oracle functions on the vi...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

You can disable Power Query's feeble attempts at guessing column types. You can also override them as part of the script. Change the column to "Whole Number"

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks @Ibendlin, but the client wants to avoid any transformations on power bi side.

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      try TRUNC(#number)

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        We also used TRUNC and TO_NUMBER, nothing has worked so far.