Forum Discussion

Zindros's avatar
Zindros
New Member
10 years ago
Solved

encrypted data

Hi all,   does anyone know if Desktop PowerBI can read and transform MS SQL encrypted data ?
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi Zindros,

    As per my test, when I encrypt a column of data for a SQL Server table and import the table to Power BI Desktop, Power BI Desktop cannot read and transform the data of encrypted column.  





    As illustrated in the above figures, the Binary type of Data Model column is currently not supported in Power BI Desktop. Binary Data columns are removed from the resulting table in Power BI Desktop.

    Thanks,
    Lydia Zhang

krati's avatar
krati
Regular Visitor
9 years ago

I am facing same issue and Power BI desktop fails to decrypt the binary data  and says "Expression Error - Value was not specified". Below is the query in Advanced editor: TableName{[Column1=Binary.FromText(...)]}[Column2]

 

Please suggest what are the steps to follow for displaying encrypted columns data in Power BI desktop report. Also, what are the steps required to make those columns visible once published to app.powerbi.com