Forum Discussion

advtech's avatar
advtech
New Member
2 years ago

How to display Sensitive label Column from SharePoint Online Document Library to Power BI Desktop

Hi All

 

Here is my query, I have SharePoint Online, a Document Library and in that Document Library, applied sensitive label

Now on Power BI, I managed to get the document library data via OData Feed

 

Below is a screenshot of the sensitive label column on the document library for each document



How can I get the "sensitive label column" value onto my Power BI report 
Thanks


 

General Comment

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, advtech 

     

    Power BI semantic models that connect to sensitivity-labeled data in supported data sources can inherit those labels, so that the data remains classified and secure when brought into Power BI.

    Currently supported data sources:

    • Excel files stored on OneDrive or SharePoint Online

    For more information, please refer to the following documentation: Sensitivity label inheritance from data sources in Power BI - Microsoft Fabric | Microsoft Learn

     

    Best Regards,

    Community Support Team _Charlotte

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

  • christinepayton's avatar
    christinepayton
    Icon for Most Valuable Professional rankMost Valuable Professional
    2 years ago

    If you make a second query and use the SharePoint Online list connector and connect to the library, it has a column called "Sensitivity Label". You can merge on the item ID to combine the two tables and disable load of the second table if you want it all together. The list connector is the one that has all the metadata in it. 

     

    Assuming that this column has the label in it - I'm not using the labels in my dev tenant so the column is blank, but there is a column for it. 🙂