Forum Discussion
Power BI refresh Issue
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.
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.
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?
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.