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

[advtech]

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

[christinepayton]

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. 🙂

[Anonymous]

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.