Forum Discussion
Password Protected Excel to load in power bi
Power BI does support loading password-protected Excel files, so the issue might not be related to that. The "Data is corrupted" error message suggests that the Excel file might indeed be corrupted.
Here are some possible workarounds you can try:
Try repairing the Excel file: Open the file in Excel, go to "File" > "Options" > "Trust Center" > "Trust Center Settings" > "Protected View", and uncheck "Enable Protected View for files originating from the Internet". Then, save the file and try loading it in Power BI again.
Save the Excel file in a different format: If repairing the file doesn't work, try saving it in a different format, such as CSV or text file. Then, import the data into Power BI from the new file format.
Use a third-party tool: If none of the above methods work, you can try using a third-party tool to extract the data from the Excel file. There are various tools available online that can help you bypass password-protected Excel files and extract the data into a new file format that can be loaded into Power BI.
However, it's important to note that bypassing password protection on an Excel file might be a violation of privacy or security policies, and should only be done with permission from the owner of the file.
Can you please let me know how power bi supports password protected file. I have done a through research and I facing similar post in community as well. Is that connector is available in the new version????
Its not about the data corruption though it is very misleading message we are getting. I tried with simple excel as well with and without encryption. I am not able to load encrypted file. Please help me with the steps to load passoword protected excel file
Hi amritad - Excel files with password protection aren't currently supported. Here's the idea for the feature that you can add your vote to.
An alternative solution in the current state would be to keep the file in a secure location and load from there.
Regards,
Daniel
