Power query and pass protection of files?

[n.kehayova]

Hello,

Just a principle question - can power query read a pass protected file? And if the query is linked to a folder, can, someway with a mapping of file/pass read all pass protected files there?
And if yes, how?

Until now what I got from the forums is write a VBA which opens all files and inputs password before refresh and they are opened while the refresh is running, but it will be too slow, given the number of files I'm handling.

 

[Rudi]

...can power query read a pass protected file?

No. It unfortunately cannot read a password protected file.

You cannot even use parameters to pass the password to the query, so using a table to store the workbook and password is also out of the question.

As you have determined, the only way is to use VBA or other manual processes to remove the passwords from the source files before you open and transform them with Power Query.

 

[n.kehayova]

Ok, thanks a lot!