![]() ![]() 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"?ģ. The storage space it uses is part of the organization's total storage limit. 2 We recommend monitoring the Recycle Bin and emptying it regularly. See Add storage space for your subscription. You can purchase an unlimited amount of additional SharePoint storage. 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).Ģ. 1 Learn how to find the total and available storage for your organization. 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. Me and colleagues have Office 365 E3 licences. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |