Summary
In this chapter, we learned how to implement RLS and OLS in Power BI Desktop and third-party tools. We now know how to manage the roles within the Power BI Service and in Power BI Report Server. We learned what static and dynamic RLS approaches are and how to implement them in our data model to make the relevant data available to authorized users. We also learned how the mixture of RLS and OLS implementation works and what crucial points to note when designing a security model. In the next chapter, Dealing with More Advanced Data Warehousing Concepts in Power BI, we look at slowly changing dimensions, and degenerate dimensions.
Join us on Discord!
Join The Big Data and Analytics Community on the Packt Discord Server!
Hang out with 558 other members and enjoy free voice and text chat.