Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Power BI cannot convert to integer from Oracle

Submitted by Anonymous on ‎08-05-2022 08:35 AM

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
See more ideas labeled with:
8 Comments (8 New)
Comments
AilsaTaoYe
Regular Visitor
‎08-09-2022 12:57 AM

Hi @Anonymous 

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

Anonymous
Not applicable
‎08-10-2022 05:19 AM

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
‎08-17-2022 10:24 PM

Hi @Anonymous 

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

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable
‎08-19-2022 07:31 AM

Hi @Anonymous 

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

kdevroede
Frequent Visitor
‎02-02-2023 01:58 AM

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
‎10-24-2023 11:51 PM

Hi @v-yetao1-msft ,

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

lakshmancseh
New Member
‎09-21-2024 06:51 AM

Hello,

 

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

lakshmancseh
New Member
‎09-21-2024 07:01 AM

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 ?

Idea Statuses