Комментарии:
Thankyou so much for sharing this. I implemented same in my dashboard. So the role rls is working fine. But, in the role "rls and ols" Only ols is working not rls.
With respect to this example, John cannot see the street address, but he can see all countries data.
Can u tell what m doing wrong here??
Hi, I have a requirement to build employee dashboard. The user should see the visuals only related to himself/herself not others. How to achieve this on both Power BI desktop and Service. . Also what if the supervisor wants to see all the visuals with respect to subordinates. can someone please help
ОтветитьHow do we manage RLS for different reports connected to the same dataset?
ОтветитьAside RLS RLI would be interesting to. We use RLI as Row Level Intelligence. In our case Sales people are allowed to sales of the colleagues, they can see all details except customer names if it are not customers from their region. In a database this is quite easy to solve with a table valued function, but once in a cube this is quite difficult, we don't want a separate table with customer names per viewer-region. That would solve the tick, but we have 50K customers and 63 regions ....
ОтветитьMaaaan, you go way to fast, slow down dude, it's like your going at 200MPH! Otherwise, this would be good
ОтветитьHello.
I have a two column- comments and created by that contains text values
I want to filter only those comments who entered by some specific user that belong to AD group. (This group has SharePoint access permission as members) I am checking by their name manually but I want some solution to filter the name only if user name is belong to that group.
So that if new user come
it should check automatically.
Please reply if you can suggest or anyone in this chat.
My datasource is SharePoint.
How to add row level security in power bi pagenated report...
ОтветитьUnable to apply Page Level security along with RLS. Can you please provide the pbix file please?
ОтветитьFound a bug where if your table has a date format embedded in the table, OLS will throw an error when you try to save your security configuration in Tabular Editor... I put in a PBI Support ticket and through messing with different tables landed on the fact that date format creates hidden tables (I think for Time Intelligence) which OLS does not like. Hopefully, this can be fixed in a future update.
ОтветитьHi, can I develop a report with OLS without Tabular Editor?
ОтветитьThis is one of the complex problem in PBI
Ответитьwhat happens if you have300 or so employees? is it scalable
ОтветитьWith Dynamic RLS I solve many problems. But in these days i'm thinking is it possibile to create a "SuperUser" that can bypass all RLS and can view all?
ОтветитьOld would be good if they provide an option to return a default value rather than not show at all. Ie where not permitted return 0 or. Null. Would make it useful
Ответитьhello, how can I can give permission to a user to see only a specific pages in a reporting!!
Ответитьis there any way to hide those visuals with ugly cross mark when ocl gets applied without page navigation?
ОтветитьThe problem with the page navigation - which not a lot of people know, due to how excel etc works, is that in Power BI, you can actually have multiple pages with the exact same name.
ОтветитьIn addition to rls and ols, they really need page level security.
ОтветитьSounds complicated 😕
Ответить