Power BI refresh Issue

[Anonymous]

Hi Team,

While I am trying to refresh the power bi report, I am thrown with this error - "DataSource.Error: We don't support reading encrypted workbooks" in the online service and when I am trying to open the same report throiugh power bi desktop, then also the report is not getting refreshed and showing me this error for almost all of my reports.

The data source is multiple excels stored in OneDrive and the same reports were getting refreshed a few days back and all of a sudden, it stopped getting refreshed, please advise on the next steps as I am stuck and cannot move forward and unable to identify the issue which is causing this error.

Again tried refreshing on power bi desktop and showing this error - "DataSource.Error: We don't support reading encrypted workbooks.", and none of the excels are password protected or encrypted

[Anonymous]

Hi, @Anonymous 

You'll need to confirm that the Excel file hasn't been accidentally encrypted, and even if you think the file isn't encrypted, you still need to double-check. You may need to manually check each Excel file. Open the Excel file and click "File > Info" in the upper left corner. See if there's a prompt to "Protect the workbook" or "Encrypt" (for example, "Require a password to open this file").
You'll also need to check the OneDrive file permissions and paths to make sure that the file path is valid, as the path in Power BI might be invalid if the file is moved to a different folder in OneDrive. Also recheck the data source path and update it, tap Transform data > Data source settings in Power BI to confirm that the path is correct.
Make sure that the sharing settings for the OneDrive file or folder allow access to the Power BI service. If you're using an enterprise account, check to see if Conditional Access policies, such as MFA or IP restrictions, are enabled that prevent the Power BI service from accessing files.
If the file path and permissions are correct, it could also be that the authentication token for Power BI with OneDrive has expired. In Power BI Desktop, go to File > Options and settings > Data source settings. Find the OneDrive data source, tap Clear permissions, and re-enter your account credentials.
In some cases, OneDrive files may be corrupted due to sync issues, and you can also download Excel files from OneDrive locally. Then re-upload to OneDrive and update the data source path in Power BI.

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

Hi @Anonymous  Thanks for your guidance, while I tried to check all the things, I realized that I am changing the confidentiality of the excels to "General" and saving it as "mark as final", however it automatically gettng changed back to "Confidential" and that's what is blocking me from refreshing the reports. Is there any other way or may be a way to change confidentiality to "General" for the entire set of excels stored in that onedrive folder?

[Anonymous · Accepted solution]

Hi, @Anonymous 

This may be related to Microsoft 365's Sensitivity Labels auto-apply policy. When a file is stored in a specific location, such as OneDrive or SharePoint, the system may automatically mark the sensitivity of the file (such as "confidential") based on your organization's information protection policies.
You need to confirm the automatic application policy for sensitivity labels, your organization may have enabled Microsoft Purview Information Protection policies to automatically label sensitivity labels based on file content, location, or user actions. For example: Files stored in a OneDrive folder are automatically marked as "confidential." Sign in to the Microsoft 365 Compliance Center: <https://compliance.microsoft.com>, navigate to Solutions > Information protection > Labels and check if you have Auto-labeling policies for OneDrive folders. Here, you can also complete the operation of modifying tags in bulk. Locate the Confidential label policy, edit its scope, exclude the target OneDrive folder, or create a new policy that sets the target folder's default label to General. (Since I'm not an admin, I don't see the relevant label settings)

For bulk action editing, you can also sign in to OneDrive for the web and go to the destination folder. Select all files > click on the "Sensitivity" column at the top > select "General". If the Sensitivity column is not displayed, it needs to be enabled by your administrator in the library settings. You can check the following link:

Enable sensitivity labels for files in SharePoint and OneDrive | Microsoft Learn

You can also try a temporary solution: save locally and then re-upload. If your policy is only for files in the cloud, you can download Excel files from OneDrive to your local computer. Then delete the sensitivity label from your local file, then re-upload it to OneDrive and overwrite the original file. If the tag policy is mandatory, ordinary users may not be able to modify it directly and try to change the tag manually.

Open the file in Excel and click the "Sensitivity" button on the top menu bar (usually on the right side of the toolbar). Select General or delete an existing label. When you save the file, observe if it says "This operation is blocked by policy". If blocked, you'll need to contact your Microsoft 365 administrator to adjust your label policy permissions. Contact your Microsoft 365 administrator to submit a request to your IT administrator to add your account to a permission group that allows overriding labeling, or to adjust the auto-labeling policy to exclude specific OneDrive folders, or to temporarily disable auto-labeling for Excel files. You only need to choose one of the three operations.

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Can anyone help with this error? 

"We don't support reading encrypted workbooks."

[parry2k]

@Anonymous did anything changed to the source workbooks? Can you open these workbooks in Excel?

[Anonymous]

Yes, I can open workbooks in excel but report is still not refreshing @parry2k