Forum Discussion

DaleH's avatar
DaleH
Icon for Resolver I rankResolver I
4 years ago
Solved

How to access a password protected field from MySQL on import

MySQL database has a password encrypted field.

When I import that field, it is ignored by Power BI.

When I open Power Query Editor, I am able to click the "APPLIED STEPS" value "Source" and then click on the "Data" column, "Table" value and create a Navigation step.

Power Query now displays the encrypted column as "Binary".

How do I unencrypt that field so I can use it?

Thx