Forum Discussion
Excel password protected files queries into Excel data model
Hello, Software: Excel - Office Professional Plus 2016 Issued: Password protected files Solution requested: Query password protected files into Excel Files: I used to password on the files. The f...
There is another (bad) workaround, which worked for me at least - you can it seems import the data into another Excel sheet via Power Query as long as the source data file is open; from there you can import into Power BI. The (admitedly massive) downside is that the intermediate Excel file won't refresh with the source file closed!
(I have voted on the Idea!)