Power BI does not support binary (hash) value and unable to read primary key for making joins

Help
1

I’ve created a Data Vault model using hash value as primary key. However, PowerBI can’t handle binary values and unable to make joins between tables. Please advise whether you’ve seen this issue before and if there are any solutions using dbt?

Thank you.

2

add a new computed column to your table or view
Hash( existing binary hash key column ) as hashkey_int

Note: @Mah originally posted this reply in Slack. It might not have transferred perfectly.

3

Let me know if you have used any other solution

Note: @Mah originally posted this reply in Slack. It might not have transferred perfectly.

4

Yes, it works. Thank you for the prompt response