In addition to rls and ols, they really need page level security.
@abhishekparashar27022 жыл бұрын
You can build a Pagle level security using rls .
@roberttyler28612 жыл бұрын
@@abhishekparashar2702 go on....
@athiramohan67582 жыл бұрын
@@roberttyler2861 go to 4:53 of the video, there's also a video by RADACAD where they demonstrate it in detail.
@idonjohnson69999 ай бұрын
Instead of creating separate pages, you can put the restricted columns in a field parameter and use the field(s) to link to a UPN.
@willempelser85742 жыл бұрын
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.
@anand290919872 жыл бұрын
is there any way to hide those visuals with ugly cross mark when ocl gets applied without page navigation?
@shamharoth2 жыл бұрын
I’d also be interested in this. Every time I look into OLS I’m baffled why Microsoft have implemented it like they have. I don’t understand why they don’t give the option to just return a blank value and therefore show a proper visual just with no data in the fields/measures that you don’t have permission to. We have reports that show revenue and costs, but only want certain users to see the costs - the obvious thing would be to show the cost columns as blank if you don’t have permission and not doing that means we have to maintain two sets of reports.
@anand290919872 жыл бұрын
@@shamharoth i think rather than using any external tool, it should be implemented in tool itself. Any thoughts?? Amd there are one key features which i think is utmost importance is the ability to navigate from a tooltip and also pass the slicer value when you navigate from one report to other. Any input would be useful here.
@frozentoast58502 жыл бұрын
@@shamharoth it's like they had a 6-month intern implement it in third-party software and called it a day... Power BI in general still feels like "early access" at times with all the UI changes and half-assed implementations
@maci69902 жыл бұрын
@@frozentoast5850 fully agree, with BI being a general accepted field for multiple decades now, it is insane that the tools are as immature as they are. Especially with Power BI recognized as "leader" by Gartner
@SQLTalk7 ай бұрын
Very helpful. Thank you.
@analystdnash69614 ай бұрын
I have this dashboard I am doing RLS on, it is working fine in the pbi Desktop but not on PBI Server. I have given access to the users on the pbi server and added the users to the roles but still when I do Test Role as one of the emails, I cannot see any data/charts. Can I get assistance on this.
@harryleboeuf8778 Жыл бұрын
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 ....
@adriangonzales43302 жыл бұрын
Hi, can I develop a report with OLS without Tabular Editor?
@JFancke2 жыл бұрын
Is there any way to allow a role to see all rows in one column, but only a subset of rows in another column? For example a site manager can see headcount for all sites (eg for at least 1 column in the table they can see all rows) but they can only see the "payroll" column for certain rows (eg where site = their site). I think it's only possible if you split up the table.
@littlesunshine2387 Жыл бұрын
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.
@heddyjazy62522 жыл бұрын
hello, how can I can give permission to a user to see only a specific pages in a reporting!!
@roberttyler28612 жыл бұрын
what happens if you have300 or so employees? is it scalable
@hulltl2 жыл бұрын
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
@wozturner6999 Жыл бұрын
In tableau we us cell level security as you may need to see some data but not specific cell values and it makes the need for OLS and RLS and its workarounds redundant. If your a member of Group A you can see the actual data values...but if your in Group B you see 'confidential' and its controlled within the datasource and not in a DAX masking. Especially useful when your user base is 16k users and dont wat to have to manage users on a case by case basis.
@hulltl Жыл бұрын
@@wozturner6999 great to know about tablelands. powerbi with the fields parameters and easier row level security now have very effective security from the dataset levels and using tab editor you can apply object level security as well so it is now largely all there like everything there is always room for tweaks
@prasadplk90 Жыл бұрын
How to add row level security in power bi pagenated report...
@Markizoniusz2 жыл бұрын
Too bad there isn’t a better way to manage restricted columns/tables rather than this navigation. However, big kudos for showing the case that navigation trick is not secure. Makes sense but I didn’t realize it 😅
@vpenywise2 жыл бұрын
I have a complex dashboard, with multiple pages and they utilize at least 3 or 4 different "slicer sources". For example, I have 3 different filters, on 3 different pages, for "Supervisor", coming from 3 different data sets. When I implement Role-Level Security, it literally destroys my whole Dashboard's data accuracy, because it applies a SINGLE "slicer filter" to ALL pages. How can I fix that? Thanks!
@joeseroski10952 жыл бұрын
Do you have sync slicers turned on?
@vpenywise2 жыл бұрын
@@joeseroski1095 You can only sync slicers that are coming from a single data set/table. You can't sync slicers coming from different data sets/tables
@joeseroski10952 жыл бұрын
@@vpenywise Build one data model using conformed dimensions.
@bryon54912 жыл бұрын
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.
@theanxiousplanner3516 Жыл бұрын
I know this is an old comment but did you try disabling time intelligence? That worked for me when I was having the same problem yesterday :)
@MattiaRepossi2 жыл бұрын
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?
@donovan6094 Жыл бұрын
set workspace access as contributor or admin
@ashleyfiore1209 Жыл бұрын
How do we manage RLS for different reports connected to the same dataset?
@GuyInACube Жыл бұрын
RLS is managed at the dataset. Not the reports. So, any RLS applied to a dataset would be used for any reports connected to that dataset.
@subbaraod83372 жыл бұрын
Unable to apply Page Level security along with RLS. Can you please provide the pbix file please?
@sasirekha5004 Жыл бұрын
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
@schattedaenker Жыл бұрын
Create a security role in desktop and the create a dax filter with username(), then assign the role to the dataset in services. Dont forget to add the members for the role.
@user-bl4qi8wr1o2 ай бұрын
Not very good solution. 1. I prefer using field parameter then hidden pages. 2. If I have more RLS (e.g. by Regions) and more combination of OLS (e.g. Finance, Sales, etc ...) then Iwould need ALL (!) combinations to have 1 single role for every possible roles (e.g. for every Region, for Global + for Finance, Sales, Finance + Sales etc ...). I still don`t understand why a combination of more RLS + OLS is not possible.
@DarkOri3nt2 жыл бұрын
Sounds complicated 😕
@helloranjan892 жыл бұрын
This is one of the complex problem in PBI
@jeremywall5704 Жыл бұрын
Maaaan, you go way to fast, slow down dude, it's like your going at 200MPH! Otherwise, this would be good
@theanxiousplanner3516 Жыл бұрын
haha I had him at 1.75 speed as I thought he was too slow. Every brain is different!
@jeremywall5704 Жыл бұрын
@@theanxiousplanner3516 haha If you played it at 1.75 speed, you wouldn't be able to understand it, so stop trying to be clever