Forum Discussion
Using Get & Transform but files are password protected
I'm attempting to pull in multiple Excel files from a state agency each morning. I can setup the query to get the files from a Folder but they are password protected and I don't see anyway to allow for that in the Query.
I also tried setting the query to access one file but still don't have an option to enter the password... getting an error: "File contains corrupted data".
Any Ideas on how to accomplish this?
Thanks,
Jim
Hi James,
To my knowledge there is no way to access password protected file by PQ. You may vote for that idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9422748-connect-to-password-protected-excel-workbook, but it's 3 years old.
The workaround could be to share files by another way, e.g. using secure folder. Files could be synced through cloud in encrypted form and landed in unencrypted form on each client. But that's another story.
