Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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.

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.