Forum Discussion
encrypted data
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
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
Hi, I recently opened a ticket to Microsoft for this reason. The only way to read SQL Always encrypted columns is via odbc:
(And it works 🙂 )
Please also notice that RLS can't be applied in this context. I suggested to add this feature in this Idea:
Elena
