Power BI cannot convert to integer from Oracle

[gavb_rafaela]

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.

[lbendlin]

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"

[gavb_rafaela]

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

[lbendlin]

try TRUNC(#number)

[gavb_rafaela]

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

[lbendlin]

Are you using the Oracle driver or the ODBC driver?

[gavb_rafaela]

Oracle Database.

[lbendlin]

You can raise an issue at https://issues.powerbi.com . If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/

[gavb_rafaela]

Thanks! I'll do it.