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...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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

     

bbaranyai's avatar
bbaranyai
Frequent Visitor
8 years ago

That you Dale!

 

This explains.

 

Balazs

bbaranyai's avatar
bbaranyai
Frequent Visitor
8 years ago

Thank you!