How to get the Retention Label (Compliance Tag) Column to Surface for SharePoint Documents

[Anonymous]

Hi Everyone

In SharePoint Online document libraries there is a system column called "Retention Label" that users can use to tag documents with the correct retention policy to apply to each document.

When connecting to SharePoint Online sites and pulling in a list of all documents on that site into Power BI, that column is missing.

I'm looking for ideas on how to include that column.

Thanks!

[heygetnet]

Hello,

Were you able to resolve this issue?

I am trying to get the same info from SharePoint through the rest API but it only returns the custom columns.

Thanks.

[Fowmy]

@Anonymous 


Check your Power Query step where you connected to this source if the names of the columns to bring in are hard-coded in a step then, you will have to modify the query.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn