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.
Hi Anonymous，
Yes, I'm afraid that we cannot convert the data type when in direct query mode.
We may try another way, you could have a reference of this similar thread which has been solved.
Best Regards，
Cherry