Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Reading Always Encrypted columns from Azure SQL in PowerBI

Hi, we have a project requirement that we need to read data from a Azure SQL where there is sensitive data visible only to selected users - does PowerBI support reading and rending encrypted data   ...
Data Protection
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

Based on your description, I assume that you want to convert binary to hex or text. If so, you may try the following M code to see if it works.

= Table.AddColumn(Source, "Custom", each Binary.ToText([a],BinaryEncoding.Base64))
or
= Table.AddColumn(#"Added Custom", "Custom.1", each Binary.ToText([a],BinaryEncoding.Hex))

 

For further information, you may refer Binary.ToText ,Converting Binary to hex value or numeric value .

 

Best Regards

Allan

 

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