Decryption the entities(via CDS) fields in power bi report.

[Anonymous]

Hi,

I am saikrishna, currently working in power bi report via CDS, in CDS the entity fields are encypted so can anyone hepl for decryption the entitirs in power bi.

[v-robertq-msft]

Hi, @Anonymous 

In my opinion, when you import the encrypted entity fields to Power BI Desktop, Power BI Desktop cannot read and transform the data of the encrypted columns. 

You can take a look at the following links and check if you can find out a method:

https://community.powerbi.com/t5/Desktop/encrypted-data/td-p/49713

https://community.powerbi.com/t5/Desktop/Encrypted-Fields-in-Table-of-Sql-Server-Database/td-p/493140

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-Encrypt-and-decrypt-password-field-of-contact-entity/td-p/632171#

https://community.powerbi.com/t5/Desktop/Power-BI-view-encrypted-data/td-p/1172227

Best Regards,

Community Support Team _Robert Qin

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