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 Confidential data is encrypted as well.

We have a lot of excel files which are used to feed some PowerBI Dashboards, and of course, now users are complaining that PowerBI is not able to read the files. Of course we can remove the data classification for these files, but it doesn't make much sense as they are internal.

I can imagine that Microsoft may have some solution for this, but didn't found out nothing that worked well. Anyone had such experience?

 

Thanks

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.

7 Replies

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

    Hello dmarques


    Thank you for reaching out to the Microsoft Community Forum. It seems your issue is related to Power BI's inability to access Excel files that have been encrypted using Microsoft Purview sensitivity labels.

     

    Power BI does not natively support reading encrypted Excel files with sensitivity labels, as it lacks built-in decryption capabilities and may not have the necessary permissions. However, there are a few possible solutions:

     

    1. Use Sensitivity Labels Without Encryption : If encryption is not mandatory, you can apply sensitivity labels without enabling encryption. This allows Power BI to read the data while maintaining classification.

    2. Modify Sensitivity Labels in Microsoft Purview : Update the sensitivity label in Microsoft Purview > Information Protection > Labels to remove encryption while retaining classification. Once updated, reapply the label to the affected files.

    3. Enable Microsoft Information Protection (MIP) Sensitivity Labels in Power BI : Configure MIP sensitivity labels within Power BI to ensure it respects the classification while allowing access.

    If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

     

    Thank you!