Others

How to Fix Power BI Error: We Do Not Support Reading Encrypted Workbooks

Amos GikundaAmos Gikunda Oct 22, 2026 873 views

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.

How to Fix Power BI Error: We Do Not Support Reading Encrypted Workbooks
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.
Before you start

Ensure you have the appropriate permissions or passwords to access and modify the security settings of the original Excel workbook.

Solution 1Recommended

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.

1
Open the source file

Open the affected Excel workbook using your spreadsheet software.

2
Remove password encryption

Navigate to File > Info > Protect Workbook. Click on 'Encrypt with Password', delete the contents of the password field, and click OK.

3
Clear sensitivity labels

If your organization uses Microsoft Information Protection, change the sensitivity label from a restricted status (like Confidential) to 'General', 'Public', or 'Non-Business'.

4
Save a clean copy

Save the file as a new copy, then update your Power BI data source settings to connect to this newly saved, unencrypted workbook.

Remove Workbook Encryption and Sensitivity Labels
Data Security Reminder: Always ensure that removing encryption complies with your organization's data security and privacy policies.
Free Microsoft Office alternative

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. 1. Download the software: Download and install WPS Office for free from the official website.
  2. 2. Open your data file: Use WPS Spreadsheets to open your Excel data sources quickly.
  3. 3. Prepare and save: Modify your data, remove standard document protection, and save the file in .xlsx format for seamless integration with other tools.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Easily view, edit, and manage basic document passwords to prepare unencrypted data for reporting.Lightweight software package with a familiar, easy-to-navigate user interface.Includes built-in advanced data analysis and visualization tools without subscription fees.
microsoft office alternative - wps office

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.