Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts,
I have a requirement in our project, as I am creating Adhoc reports(there are no measures or filters or any logic).
The requirement is like "For a particular report user A will be able to see all fields including PII but user B will see only the non-PII fields; other fields will be masked for them. Then B will be able to download the report but A can download the report with PII attributes as masked"(While export).
Looking Forward to your response.
Thanks,
Hina
Hi Heena,
For security, you can make use of OLS (Object-Level Security) functionality, where you can enable specific tables or columns from report viewers, check below two links, one from Microsoft and one good tutorial as example
Regarding to downloading or not, you can use the checkboxes at the time you grant permission to the specific users, not sure if you can create a group A/B with those patterns.
Hope that helps.
Regards,
Douglas.