Forum Discussion
Microsoft data classification and PowerBI
Hello dmarques
Thank you for the update. Glad to hear that you’ve found a solution that works in most scenarios.
Regarding the issue with Power Query reading encrypted Excel files, I had previously shared a reference link in my earlier response that provides relevant information on this limitation. You may not have had a chance to review it yet, so here it is again for your reference:
Enable sensitivity labels in Fabric and Power BI - Power BI | Microsoft Learn
As the issue has been resolved, kindly consider marking this as the Accepted solution to help others find it easily.
Thank You.
Hi dmarques
We understand your concern. To clarify, Power BI does not support opening encrypted files (whether online or offline) when they are protected with Microsoft Purview sensitivity labels that include encryption.
The note you referenced refers to offline access limitations, meaning that even if encryption settings allow offline access, certain apps such as Power BI Desktop still won't open encrypted files when offline. However, this does not imply that Power BI can open encrypted files when online.
- Power BI does not natively support decrypting Purview-encrypted files, whether stored online or offline.
- Even when files are stored in SharePoint Online or OneDrive, Power BI is unable to process them if they are encrypted with Purview sensitivity labels.
- Power BI currently supports sensitivity labels for reports, dashboards, and datasets but not for encrypted data sources.
Thank You!
Hi,
We've found the solution which works in 2 scenarios, and we're just missing one scenario.
So we've enabeld 2 options on PowerBI tenant admin:
And now we can read encrypted excel files readed directly on PowerBI or via link.
The only thing we can't do is to read power query via excel files, which prompt this error on Power BI:
Thanks
Hello dmarques
Thank you for the update. Glad to hear that you’ve found a solution that works in most scenarios.
Regarding the issue with Power Query reading encrypted Excel files, I had previously shared a reference link in my earlier response that provides relevant information on this limitation. You may not have had a chance to review it yet, so here it is again for your reference:
Enable sensitivity labels in Fabric and Power BI - Power BI | Microsoft Learn
As the issue has been resolved, kindly consider marking this as the Accepted solution to help others find it easily.
Thank You.