Forum Discussion
Reading encrypted workbooks error from auto refresh
Anonymous, Thanks for reaching out Fabric Community Support.
Tahreem24, Thanks for promt response.
Anonymous, According to the error message, this is due to your current Workbooks being encrypted thus preventing from auto-refreshing. When connecting to workbooks using Power BI Desktop, credentials and permissions have been established in PBI Desktop, but these may not transfer during the auto refresh process, resulting in the error. If you want to enable automatic refresh using Power Automate, the only current way is to remove the encryption.
Best Regards,
Prashanth Are
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Anonymous ,By any chance do you have password protected excel file? If yes, so this might be the issue.
You can refer the below post for your reference: