Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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"
Thanks @Ibendlin, but the client wants to avoid any transformations on power bi side.
try TRUNC(#number)
We also used TRUNC and TO_NUMBER, nothing has worked so far.
Are you using the Oracle driver or the ODBC driver?
Oracle Database.
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/
Thanks! I'll do it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.