Forum Discussion
HashBytes Conversion
I have run into a problem with PowerBI which does not support binary data. We are currenly using the Data Vault model where the Keys are stored as binary(64) generated from HasBytes('SHA2_512', ...)....
BigInt has a storage size of 8 byte; 64 byte binary never fits in. You can try it with varchar instead. Keep in mind, a hash is no guarantee for unique values; it's just a hash.
select convert(varchar(64), HashBytes('SHA2_512', 'Test Test Test'))