Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello I get this messsage OLE DB or ODBC error: [DataSource.Error] Credentials are required to decrypt this workbook, but none were provided..
This happens when I try to add data or edit data in one of my excel files. Has anyone ever experienced this before and could help?
Hi @nguyendhenry ,
Has your problem beed solved? If so, please kindly accept the helpful reply as solution, then we'll close the thread, other people who has the similar problem will benefit from here. Thank you!
Best regards,
Community Support Team_yanjiang
Hi @nguyendhenry ,
The error message "Credentials are required to decrypt this workbook, but none were provided" usually occurs when the Excel file is password-protected and you are trying to access it without providing the correct credentials. You can try the following steps to resolve the issue:
Check if the Excel file is password-protected. If it is, you need to provide the correct credentials to access it.
Check if the credentials you are using to access the Excel file are correct. If not, you need to provide the correct credentials.
Check if the Excel file is corrupted. If it is, you need to repair or recover the file.
Check if the Excel file is located in a network location. If it is, you need to check if you have the necessary permissions to access the file.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for offering some solutions. How do I check if the credentials to access excel file is correct? I'm using the same logins for both and cleared all permisions in the data source settings.
Take a look at this thread: https://community.fabric.microsoft.com/t5/Desktop/Failed-to-decrypt-credentials-error/td-p/1791881