How to Fix Power BI Error: We Do Not Support Reading Encrypted Workbooks
Question details
The user needs to resolve an issue where Power BI fails to read an Excel data source due to workbook encryption or security labels.

- Product
- Power BI / Microsoft Excel
- Device & OS
- not provided
- Scenario
- Importing or refreshing an Excel data source into Power BI
- Observed behavior
- Power BI blocks the data connection and displays the error message 'We do not support reading encrypted workbooks', even when the Excel file does not prompt for an opening password.
Ensure you have the appropriate permissions or passwords to access and modify the security settings of the original Excel workbook.
Remove Workbook Encryption and Sensitivity Labels
Remove password protection or sensitivity labels from the Excel file and create an unencrypted copy for Power BI to read.
Power BI cannot parse Excel files protected by Information Rights Management (IRM), sensitivity labels, or traditional password encryption. Removing these protections from a copy of the file is the most direct way to restore the data connection.
Open the affected Excel workbook using your spreadsheet software.
Navigate to File > Info > Protect Workbook. Click on 'Encrypt with Password', delete the contents of the password field, and click OK.
If your organization uses Microsoft Information Protection, change the sensitivity label from a restricted status (like Confidential) to 'General', 'Public', or 'Non-Business'.
Save the file as a new copy, then update your Power BI data source settings to connect to this newly saved, unencrypted workbook.

Seek Assistance in the Power BI Community
Consult Microsoft Power BI specialists if organizational policies prevent you from removing encryption from the source files.
Manage Excel Data Easily with WPS Office
While Power BI enterprise encryption issues are specific to the Microsoft ecosystem, WPS Office provides a completely free, lightweight, and easy-to-use alternative to Microsoft Office for your daily spreadsheet editing, formatting, and data preparation needs.
- 1. Download the software: Download and install WPS Office for free from the official website.
- 2. Open your data file: Use WPS Spreadsheets to open your Excel data sources quickly.
- 3. Prepare and save: Modify your data, remove standard document protection, and save the file in .xlsx format for seamless integration with other tools.

Frequently Asked Questions
Why does Power BI say my workbook is encrypted when it doesn't have an opening password?
Your organization may be applying Microsoft Information Protection sensitivity labels or Information Rights Management (IRM) policies in the background. Even if there is no visible prompt for an opening password, Power BI recognizes the underlying file protection and blocks access.
Can I simply type the password into Power BI to decrypt the Excel file?
No. Power BI currently does not feature a built-in prompt to enter or store passwords for encrypted Excel files. The encryption must be removed from the file itself before it is imported into Power BI.
Are there automated workarounds to import encrypted Excel data into Power BI?
A common workaround is to use an automated script or flow (such as Power Automate) that extracts the data from the encrypted file and dumps it into a secure, standard CSV or unencrypted XLSX file in a secure location, which Power BI can then safely read.




