Forum Discussion

bbaranyai's avatar
bbaranyai
Frequent Visitor
8 years ago
Solved

While pulling a table from Oracle database Power Query auto adds multiple list and table columns

Hi,

 

I just experienced a strange behavior of Power BI Desktop Query Editor.

When I pull a database table using select * from, I get the entire table correctly loaded (160 columns).

However when I use Import table functionality, Query Editor adds multiple columns to the original 160 (+40 in my case...), which seem to be list and table columns.

I have the option to unpivot any of them.

When I tried unpivot on a list column it folded out into two additional columns: 

(1) Attribute

(2) Value - this one is a record....

 

Can someone explain what is going on?

 

Thank you

Balazs

 

 

  • Hi bbaranyai,

     

    This is a feature of Oracle.Database. Please refer to Oracle.Database. You can add ", CreateNavigationProperties=false" in the Advanced Editor to work around this feature.

    While_pulling_a_table_from_Oracle_database_Power_Query_auto_adds_multiple_list_and_table_columns

     

    Best Regards,

    Dale

     

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi bbaranyai,

     

    This is a feature of Oracle.Database. Please refer to Oracle.Database. You can add ", CreateNavigationProperties=false" in the Advanced Editor to work around this feature.

    While_pulling_a_table_from_Oracle_database_Power_Query_auto_adds_multiple_list_and_table_columns

     

    Best Regards,

    Dale