Dealing with confidential data in Power BI Desktop (without Publishing)

Thanks amitchandak for the information. I really like the concept of Dynamic Data Masking.

I'm not connecting to Access via Get Data > SQL Database but by Get Data > Access Database so am unsure about the ability to run SQL statements to apply the Dynamic Data Mask.

Not as efficient as your suggestion but am investigating an alternative solution where I can use Crystal Reports Scheduler to schedule the export of the data I need from the Access Database.

I'll connect the Owners report directly to the Access Database but will schedule the export the non confidential data to a csv file which will be the data source for the Managers report. This should prevent any confidential information from accidentally being surfaced.