Forum Discussion
Limit objects visibility with OLS
Hello,
I have a quite simple issue and wanted to check if there was a workaround with OLS.
I need to build a dataset for our end users.
I also need to hide a fact table because I'm applying security rules through DAX to its fields and don't want users to bypass those rules by creating new measures on their own.
I tried OLS on the table but as you know, my measure breaks for users of this role.
So is there a way to make this table (or even some fields) invisible when connecting from Power BI desktop ?
Thanks in advance
3 Replies
Hi， WSeirafi ；
Create a report that uses OLS
Like RLS, OLS is also defined within model roles. Currently, you can't create OLS definitions natively in Power BI Desktop.To create roles on Power BI Desktop datasets, use external tools such as Tabular Editor.
You could refer to this offical document.Object-level security (OLS) with Power BI - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi !
As said in my first message, I already tried OLS on the table concerned, but the result ends up with measures that these role users don't havec access to. I want them to hide the table from them, but still see the result of the measure that is using column from that table.
Is it possible ?
Hi, WSeirafi ;
May be In desktop you could could try to hide table then public to service, then share to others ;
if not ok I think it's not support. Because there is no permission to access the table, it means that there is no permission on the data of the table, so the measures it produces must also have no permissions.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
