Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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: Investigating
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

 

Anonymous
Not applicable

Hi @gavb_rafaela 

Did you restart your Desktop and then connect to Oralce again ? 

 

Best Regards,
Community Support Team _ Ailsa Tao

gavb_rafaela
Regular Visitor

Hi @Anonymous 

Yes, I already restarted, made a new connection in Power BI and it still doesn't recognize the type.

kdevroede
Frequent Visitor

Is there a solution for this problem? We are experiencing the same issue and doing a conversion at PBI side causes folding to fail and increases CPU consumption at PBI side.

sk30
Frequent Visitor

Hi @v-yetao1-msft ,

Have we found a working solution for this as we're still facing this issue. Thanks

lakshmancseh
New Member

Hello,

 

Any solution found on this yet ? I am also looking for the solution. Please help.

lakshmancseh
New Member

Hi,

 

I imported a table from Oracle database into POWER BI. It has NUMBER datatype. SIGMA symbol is being shown before the NUMBER datatype column in POWER BI. Is there any impact because of this ?

This widget could not be displayed.