Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
PSBR
Frequent Visitor

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 is can i use those fields to develop my PBI Report, if i created that report can i able to see the data. Any body have idea on this........

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
kuldeep-dwivedi
Advocate I
Advocate I

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

Hi Kuldeep, 

 

How did you decrypt the value in Power BI? 

v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.