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 access. 

 

However once published, we can't see the masked data, there all zero out. How do I go about making users see the unmasked data if they also have unmasked access in the SQL server.

 

Thanks

 

-Yes we have SQL Server 2016 and up

Need Help

1 Reply

  • 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