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.
Hi,
Not a techinical issue but was hoping to get some feedback on how this issue is dealt with by any users with experience with this.
My company is implementing a new HR and Payroll system which to report on requires separate Business Objects licensing.
Now we already have BI devs but the CFO is adamant that they cant be allowed to see sensitive data.
Surely HR departments cant be expected to have their own report devs.
How have other organisations dealt with this?
The whole point of datawarehousing is the consolidation of data, is there any best practise I can point management to?
Thanks
Jon
Hello @Anonymous
You should look for row level security in Power BI.
You may find following articles helpful in this context
https://docs.microsoft.com/en-us/power-bi/service-admin-rls https://radacad.com/row-level-security-configuration-in-power-bi-desktop
https://radacad.com/row-level-security-configuration-in-power-bi-desktop
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
To implement the security, someone has to have access to the data.
At the moment, I'm told no dev within the organisation should be able to see certain fields.
Sounds likes it is not practical and if these constraints have to be in place, the reporting will need to be outsourced.
My question is more, is this a normal restriction?
@Anonymous
I had been part of such projects where confidentiality of the data was a prime concern. In such scenarios, we design the report/data model using the dummy data. All row level security also being applied during this. And then once it has been tested, the report can be connected with the live data, to which, access can be restricted. The finance team/CFO team can be the owner/admin of the report and they can control who can have access to what level of data.
Hope this makes sense.
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
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.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |