Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have a dataset in which one field or column of data has sensitive information that should be restricted to a subset of users when creating reports from the dataset. Is there a way to restrict access to a specific field/column based on role or some other setting?
Solved! Go to Solution.
Hi @mgaynor ,
You can use the Object Level Security in Power BI. Create a new role in power desktop, and set the column you don't want to show in the role to none in Tabular Editor. Here is a good video for your reference: https://bielite.com/blog/object-level-security-power-bi/
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @mgaynor ,
You can use the Object Level Security in Power BI. Create a new role in power desktop, and set the column you don't want to show in the role to none in Tabular Editor. Here is a good video for your reference: https://bielite.com/blog/object-level-security-power-bi/
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thanks for the info. It's great to see that its possible but frustrating that it's a third party application and not embedded in the Desktop app.
@mgaynor Yes. if you have Premium, you can use Object Level Security (OLS): Analysis Services tabular model object-level security | Microsoft Docs
Otherwise, you can do something like the following: Column Level Security - Microsoft Power BI Community
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.