8/5/2023 0 Comments Office 365 e3 security![]() Will this solution be in fact secure, meaning will my colleagues be prevented from somehow accessing the PowerQuery and removing the filter thus seeing rows that are "not theirs"?ģ. Does it seem like a reasonable solution, or am I overthinking this and is there a simpler method? (just for context, in parallel I'm exploring Power BI with RLS solution, but colleagues are more comfortable with Excel for now, so I have to at least try this).Ģ. I know there's no way to let people see only part of a workbook, so I'm thinking of a workaround: I would create one additional child Excel file for each colleague, in these child files create a Power Query which would connect to the master file and filter the data by column A, and then share these child files with read only permissions with colleagues.ġ. Column A identifies who should be able to see what. This file contains many rows of data, and I want to grant each colleague a way to see some, but not all rows. I have an Excel master file saved in a SharePoint site. It has been designed to allow for quick access to critical security information, so you’re able to stay on top of your organisation’s security in real-time. The Microsoft 365 E5 Security add-on works as a subset of the Microsoft 365 E5 license that gives organizations the chance to access Microsofts most advanced security technologies without having to pay for a full E5 license. ![]() Me and colleagues have Office 365 E3 licences. The Microsoft 365 security centre combines protection, detection, investigation, and response to email, collaboration, identity, and device threats, in a central portal. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |