cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI cannot convert to integer from Oracle

Hey,

We are bringing in an integer from Oracle, but the power query always recognizes it as a decimal number. We already tried to use the CAST ( #number as INT ), TO_INT, TRUNC and TO_NUMBER Oracle functions in the view, but it didn't work.
The customer wants to avoid any transformation on the power bi side.
The connection it uses is Oracle Database.

Status: New
Comments
AilsaTaoYe
Regular Visitor

Hi @gavb_rafaela 

You can choose Never detect column types and headers for unstructured sources in Options => GLOBAL => Data Load .  Then restart your Desktop , you will find that Power Query will not transform your data .

AilsaTaoYe_0-1660031632865.png

Best Regards

gavb_rafaela
Regular Visitor

Hi @AilsaTaoYe,
Thanks for the help, but I just disabled it and it still has decimal type.

gavb_rafaela_1-1660133879925.png

gavb_rafaela_2-1660133939230.png