Oracle Binary column - not showing

[pfalicoff]

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

[v-jiascu-msft]

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

[v-jiascu-msft]

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.

Best Regards,

Dale