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 f...
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.