Forum Discussion

PSBR's avatar
PSBR
Frequent Visitor
8 years ago
Solved

Encrypted Fields in Table of Sql Server Database.

Hi Every one,   I have few Encrypted columns in my table of database,means my data is encrypted no one can able to see the data without using encryption password, It is fully secured. My question i...
General Comment
  • Anonymous's avatar
    Anonymous
    8 years ago

    PSBR,

    I made a test before, it is not possible to read decrypted data in Power BI. After you import the encrypted fields into Power BI, you will not be able to see these fields in Data view unless you transform the binary columns to text columns in Query Editor of Power BI Desktop, but please note that the text columns still contain encrypted data. See this similar thread.


    If you need to read decrypted data in Power BI, you would need to firstly decryped the fields in SQL Server , and then import data to Power  BI.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

I'm using MySQL with Power BI and trying to import decrypted value but it was showing data as Binary. I used CAST function to convert Binary into CHAR and then it works for me.

 

-Kuldeep

  • Nandu2520's avatar
    Nandu2520
    Icon for Helper I rankHelper I
    3 years ago

    Hi Kuldeep, 

     

    How did you decrypt the value in Power BI?