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 view, but didn't work.

Need Help

8 Replies

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