This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 84%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
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?
[1]: /api/attachments/69577-image.png?platform=QnA [2]: /api/attachments/69490-image.png?platform=QnA [3]: /api/attachments/69617-image.png?platform=QnA [4]: /api/attachments/69623-image.png?platform=QnA
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
If you were using Tabular model, you could find a property called "Column Encryption Setting" that can easily resolve this issue . As in Use Always Encrypted data with SSAS and Power BI
It is proved, that for Multidimensional Cube we could also use the method mentioned in this article above.
Thanks for your feedback and Darren's suggestion. So I edit this post, it could give the correct solution.
Hi,
Was this helpful? Any updates?
Followed the steps in your first link (Always Encrypted data with SSAS....)
Worked perfectly in my multi-dimensional model. Thanks!
Now - next puzzle....
I am also creating a tabular mode cube. Datasource is created and I can add tables no problem.
But again, when I read a table with encrypted columns, it displays the encrypted text. No error this time like in multi-dimension mode, but no decryption.
I have created the model.bim as Compatibility Level: SQL Server 2019 / Azure Analysis Services (1500)
Unlike earlier modes, this does not present with any "Encryption" choices.
Any guidance for this scenario? I don't believe transloading is not an option as it would violate our data at rest policies.
Hi，
It seems this is one question that worth to be separated in one independent thread, how do you think ?
Could you help kindly to close this thread and mark helpful answer and open a new thread so we could work on that ?
Thanks for you understanding ! :)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 47%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
I think this is actually the same issue. You would use the same approach as the one in the link above, the only difference is that for tabular you need to enable legacy data sources. The following article has details at the end about a registry key that needs to be edited to expose the legacy UI, then you need to use a legacy data source for your model so that you can enable the always encrypted settings.
Indeed - will close and open new...
I have not tried this myself as we don't use multi-dim anymore at my work. But the same steps in the article @Lukas Yu -MSFT linked for Tabular should work for multi-dim. The article talks about using the legacy data sources instead of Power Query and the legacy data sources are the same ones used by multi-dim.