Latest Enterprise DNA Initiatives

Decoding of encoded rows in power query

Hi all, I get from my database at employee data encrypted values at the date of birth. Can someone help me to decrypt this in Power Query. Thanks in advance

test.pbix (96.4 KB)

@Mario What have you tried so far?

@AntrikshSharma Nothing, I still have no idea with the task

@Mario What is the kind of encryption used?

@AntrikshSharma i am not sure but i think a hash coding

@Mario I did a lot of Google searches and didn’t see a way to decrypt it, who is sending this data to you? You should ask your Database admin to run a query in database itself to decrypt it.

A hash is one-way … AFAIK it can’t be decrypted, only compared to. In any event, this should be decrypted in the source … even if you know the algorithm used, it likely has a source seeding that will be difficult to replicate and even if it works for your sample today, may be fragile.

As a matter of first principles, however, do you even need date of birth in your report? The data was probably encrypted to prevent access from outside, so perhaps should not be used at all (if it is in fact needed, can the calculation be done in the source [e.g., Age?]?)

Greg

3 Likes

Hi @Mario, we’ve noticed that no response has been received from you since the 4th of January. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!

A response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!