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.
