Forum Discussion
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 confident...
LongRule Looks like I can only see the right-hand version of the data. And it appears none of the "N" marked records are anywhere in the file's xml either. It may be wise to look at the customXML inside the zip container. It contains a blurb of information, but that is somehow encoded. But it isn't base64 (I tried).
- Thank you so much for your insights!
Your confirmation that only the non-confidential, 'N' marked records are visible and not embedded elsewhere in the file's XML is reassuring. It's great to hear that the Power Query effectively restricts access to the confidential data.
Any further guidance on how to ensure that this part of the file does not inadvertently expose sensitive information would be greatly appreciated.
Thank you once again for your valuable assistance!
