I have a dimension table containing 3 Always Encrypted attributes.
In the database they are defined as varchar(). Shown for example is the 'Account' attribute. The encrypted contents is a binary string. SSMS browsing decrypts and shows the data as expected.
However, SSAS thinks the column is binary (and thus the key is binary) - (Image 1)
and an error is thrown (Image 2)
I have tried setting the key column to the table key, name column to the account attribute, everything I can think of...no help.
The furthest I get is when I set the key column to that of the table itself, then the name column to 'Account' as shown (Image 3)
On browsing that at least shows the encrypted data... (Image 4)
But how can I browse decrypted data here?
: /api/attachments/69577-image.png?platform=QnA : /api/attachments/69490-image.png?platform=QnA : /api/attachments/69617-image.png?platform=QnA : /api/attachments/69623-image.png?platform=QnA