Forum Discussion

pfalicoff's avatar
pfalicoff
New Member
8 years ago

Oracle Binary column - not showing

Hello..

 

We are trying to build our dataset, using the query builder, making relationships between tables where the PK is a binary raw type column. The problem, is Power BI, doesn't show this columns, so we can't make the relationships. We don't want to build the dataset with a predifined sql, as this is not performant.

 

Any help will be appreciate it.

 

Microsoft, never answer or help on this issue. Or even advised if this will be resolved in future versions of Desktop,

 

Regards

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi pfalicoff,

     

    It would be a disaster to display a binary directly. Actually, there are many workarounds (or solutions) in the Power BI. 

    1. Combine the binaries. If they are a part of the supported types in the snapshot, you can combine them. Please refer to desktop-combine-binaries.

    2. If the binaries are simple strings, you can try to transfer them into TEXT. (only Import mode supported.)

    3. If you still have some other ideas, please create them here.

    Oracle_Binary_column_not_showing

     

    Best Regards,

    Dale

     

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi pfalicoff,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

     

    Best Regards!
    Dale