Power BI Column Level Security - Part 1 - Direct Query Method

Protect that data! Row Level Security (RLS) is great. Object Level Security (OLS) is awesome!

What about Column Level Security (CLS)?

Natively, Power BI does not support CLS within the tabular model. This series of videos goes over several different ways that you can bring CLS functionality INTO your Power BI reports!

Part 1 - Direct Query Method
This video goes over how you can use a mixture of Cached Data and Direct Query to a source in order to achieve Column Level Security!

NOTE: This example works in BOTH Power BI AND Paginated Reports!