Data classification and Dynamic Data Masking in SQL

[DebbieE]

If we were to make use of Data Classification https://docs.microsoft.com/en-us/sql/relational-databases/security/sql-data-discovery-and-classifica... And Dynamic Data Masking https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-ser... in our Azure SQL DB and then import into Power BI.

I wondered what would happen on the Power BI Side. Would the data just loose its masking and classifications?

I would love to get some extra information on how these SQL services are brought through (or not) into Power BI?

[DebbieE]

Interesting stuff. Thank you

[v-luwang-msft · Accepted solution]

Hi @DebbieE ，

For the moment, the data obtained by Power BI connection to SQL is the same as the data returned by querying in sql with the same account.

About Dynamic Data Masking , when you use a user that sees data in a table in the database that is encrypted, then using that user to connect to the corresponding table in SQL using Power BI, the data displayed will also be encrypted.

Refer :

SQL,user:MaskingTestUser 

Power BI,login user:MaskingTestUser:

However, when querying the data in the table, intuitively the data does not change, so it seems to me that the results from connecting to PowerBI Desktop are also consistent with the results returned by select queries in sql using the account logged in to PowerBI Desktop.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien