A More Flexible Security Setup in Power BI
In a previous video, I covered how to set up Row-level Security for your reports in Power BI. This post is going to build on that foundation, so make sure that you start from there.
In some cases, we don’t want to create hundreds of roles to suit business needs and to accommodate proper Data Security settings.
That’s when Dynamic RLS comes in handy!
With a little bit of DAX logic and a Users table to drive data restriction, we can create a pretty robust “access management” in Power BI.
If you want to learn how I arrived at the solution that I use make sure to watch the video.
While I know that this logic works in Power BI, it even works with large-scale models, I believe that there is still some space to further optimise it.
So if you have any idea or suggestions on how to take it even further, please let me know!
🙏Thanks for watching and if you liked this video please hit the 👍 button.
📢 Also be sure to subscribe to the channel so you never miss a new video.