Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Publishing a report with Masked Data

Hello,   I am working with data that is masked in SQL Server. The end users of this data also have access to the unmasked data.  We see the data in PowerBI Desktop obviously since we have unmasked...
Need Help
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
5 years ago

Hey Anonymous ,

 

not sure about your architecture, but if you are talking SQL Server and as you are specific about the release of the SQL Server - 2016 and up. I assume you are talkig about on-premises SQL Server.

 

If this assumption is correct their is a gateway machine installed to connect the Power BI Service with your on premises data sources. If you want the SQL Server to unmask the data, it will become necessary to configure Kerberos, meaning the user that has authenticated to the Power BI service has to be passed to the SQL Server.

This article explains how to configure Kerberos bases authentication in the context of Power BI: Configure Kerberos-based SSO from Power BI service to on-premises data sources - Power BI | Microsoft Docs

 

Hopefully, this will help to tackle your challenges.

 

Regards,

Tom