power BI mask function

carlos_tasayco
Contributor

Hello,

My table in databricks is using a function to mask PII columns, in my power BI report I am using import mode.

I notice that my report in power BI will have the PII masked depending on the privileges of the user who publish the report, it means if the user who publish the report can see unmask data every user can see the report with unmask data. 

I am trying to refresh the semantic model of the report in a databricks job, but despite the user who create the connection can see unmask data the report is still masked.

So, my question is: How can I solve this? is there a way to publish the report directly from databricks but having the report with the PII unmasked.

Thanks in advance.