Forum Discussion
How do we automate reporting using Excel Files (password Protected)
It would be 'nice to have' the functionality within Power BI/Power Query to supply a password to grab data from from Excel files but I don't think it's happened (yet?).
I'm pretty certain, vba (or perhaps an Office Script) can do most of the steps, and perhaps even refresh the query(s). It would involve some coding to grab the attachments (from Outlook?), save the workbooks, unprotected, in a given (secure?) location and let Power BI do its stuff. I don't think there'd be a need to point the PBI dataflow to this location as it would remain the same. The vba code could place/remove just what files you want to remain there.
This thread may be useful: https://answers.microsoft.com/en-us/outlook_com/forum/all/automatically-saving-of-outlooks-attachments-to/aeb121c8-e481-4f15-8b8e-39c5dc76e8fb
So rather than being fully automated, it may require a 2 step process (2 clicks?), one to grab attachments, unprotect the workbooks and save them somewhere, and one to update Power BI.
Hi Anonymous,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.
Thanks for using Microsoft Fabric Community Forum.
Hi Anonymous,
As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?
And if the provided information meets your requirements, you can also vote on that. It helps other users who are searching for this same information and find the information.
Your understanding and patience will be appreciated. Thanks for using Microsoft Fabric Community Forum.