Decrypt Data with Live Connection

[Anonymous]

Hi,

I am working on a project where we show some personal sensitive data to the people. Data is encrypted in the source DB and the encrypted data passes to power Bi via Azure Analysis servie cubes.
At the power Bi, its a live connection to the cube and the data is displayed to the respective people with row level security enabled.

However, we need to decrypt the sensitive information just before showing it to the client (probably at the power Bi end). Can you help us on how to acheive this?

Regards,

Hema

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[amitchandak]

@Anonymous , Please refer, if these can help a bit

https://community.powerbi.com/t5/Service/SQL-Server-AlwaysEncrypted-not-working-in-Power-BI/td-p/354500

https://www.kasperonbi.com/use-always-encrypted-data-with-ssas-and-power-bi/

[Anonymous]

Hi Amit,

Here he i trying to decrpyt while moving data from SQL to cube. BUt since our cube is also on cloud we dont want to have decrypted data there. We have to Decrypt only when we try to fetch the data ie while power bi report displays the data.

Thanks in Advance!

[Anonymous]

Hi @Anonymous 

You may refer to this blog :

Access Azure SQL Always Encrypted Data in Power BI Reports or Azure Data Factory using Managed Identity and ODBC

I hope it could help you solve your problem.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.