Forum Discussion

dmarques's avatar
dmarques
New Member
1 year ago
Solved

Microsoft data classification and PowerBI

Hi,   My company is starting a data classification project using Microsoft Purview. We've defined 3 levels of classification, which are Public, Internal and Confidential. The Internal and Confident...
Data Protection
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    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.

dmarques's avatar
dmarques
New Member
1 year ago

Hi,

Thanks for the reply and clarifications. Do you have any official Microsoft link with that information?

I really think it's kind of strange that Microsoft has one product to encrypt data and another product, within the same ecosystem which can't decrypt that data. It doesn't make much sense.

Thanks

v-karpurapud's avatar
v-karpurapud
Community Support
1 year ago

Hello dmarques 

At present, there is no specific Microsoft documentation that directly addresses this particular issue. However, there are relevant resources that provide insights into Microsoft Purview sensitivity labels and their integration with Power BI. Kindly refer to the following official Microsoft documentation:

 

Sensitivity labels from Microsoft Purview Information Protection in Power BI - Power BI | Microsoft
Learn
Enable sensitivity labels in Fabric and Power BI - Power BI | Microsoft Learn
Apply encryption using sensitivity labels | Microsoft Learn


If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.

Thank You!

  • dmarques's avatar
    dmarques
    New Member
    1 year ago

    Thanks for the references. Well, it's still kind of odd that Microsoft doesn't state clearly if it's supported or not. Also on one of articles is says this:

    So if it doesn't work with offline files, it should with online files, or am I misunderstanding?

     

    Thanks

    • v-karpurapud's avatar
      v-karpurapud
      Community Support
      1 year ago

      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.

       

      1. Power BI does not natively support decrypting Purview-encrypted files, whether stored online or offline.
      2. 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.
      3. Power BI currently supports sensitivity labels for reports, dashboards, and datasets but not for encrypted data sources.


      Thank You!

       

      • dmarques's avatar
        dmarques
        New Member
        1 year ago

        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