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
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.

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      Are you using the Oracle driver or the ODBC driver?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Oracle Database.