Ensuring Data Privacy with Power Query: Can Shared Excel Files on OneDrive Expose Confidential Data?
Confidential File (must not be disclosed, contains huge data including disclosable parts and confidential parts)
Public File (created by importing only the disclosable parts of the above confidential file using Power Query)
In this case, can the contents of the confidential file be accessed if the public file is shared publicly via uneditable(view-only) link with onedrive?
Note: I can’t delete the Query itself because I have to update it daily. Both files are stored in the same OneDrive folder, but only one file(public file) will be shared via uneditable link with onedrive.
A link to the test file will be shared for anyone who wants to attempt a breach.
The link will be removed once the testing is complete:
https://1drv.ms/x/s!AnCpAlQd1TUAhdYv1fisUf8vrfGhzQ?e=X1RqKv
Confidential File (must not be disclosed, contains huge data including disclosable parts and confidential parts)Public File (created by importing only the disclosable parts of the above confidential file using Power Query) In this case, can the contents of the confidential file be accessed if the public file is shared publicly via uneditable(view-only) link with onedrive? Note: I can’t delete the Query itself because I have to update it daily. Both files are stored in the same OneDrive folder, but only one file(public file) will be shared via uneditable link with onedrive.A link to the test file will be shared for anyone who wants to attempt a breach.The link will be removed once the testing is complete: https://1drv.ms/x/s!AnCpAlQd1TUAhdYv1fisUf8vrfGhzQ?e=X1RqKv Read More