Forum Discussion
Hasbytes as Primary Key
Hello, We're creating a data model in sql server that combines data from multiple sources in our data lake. We're trying to build it with the future in mind as we will likely turn it into an ETL ...
I was able to switch to the CHECKSUM() function within sql server. I think this will work, but I'm waiting on some indices from our DBA group before I can actually run my verifications. However, this did come into power BI as a number so I was able to use this as the key linking the tables together. My performance is terrible w/o the indices, but I think the CHECKSUM has done what I needed it to do.
Hashbytes apparently works in PowerQuery now. I'm using this:
convert(nvarchar(50),hashbytes('MD4' ,BR.projecttitle),2)