Power Query on Password Protected Book

I have a query on the workbook that contains the query. The file (xlsm) is also password protected. When I don’t have the password on the file the query works when i reinstate the p;/w the query hangs .

What are my options. The most sensitive tab is a salaries tab.

Thank You

Allister

Hello Allister,

Right now Power BI does not support the password protected excel file. You can upvote the request if needed.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9422748-connect-to-password-protected-excel-workbook

I found an interesting Microsoft read. Hope this would be helpful.

Also, “Roles” may help if you plan very carefully.

All the best.
Indira

1 Like

Hi @AllisterB, we’ve noticed that no response has been received from you since 26th of February. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!