Sharepoint Recycle Bin as Datasource

Hi pallavi_r 

 

That is currently not possible with Power BI - not with any available SharePoint connectors.  Check this out for the workaround on how to get the data:

https://community.fabric.microsoft.com/t5/Power-Query/Use-SharePoint-Recycle-Bin-as-a-Data-Source/td-p/1756122 

Hi pallavi_r 

I'm not sure if this meets your requirements, but I was able to query the list of files (but not content of files) in a SharePoint Online site's recycle bin with this:

 

 

let
    SiteURL = "https://YOUR_TENANT.sharepoint.com/sites/YOUR_SITE",
    SharePointRecycleBin = OData.Feed(SiteURL & "/_api/web/RecycleBin")
in
    SharePointRecycleBin

 

 

Appears to refresh successfully in the service with OAuth credentials.

Hi pallavi_r 

Glad that this helped!

I did some testing at my end to locate files in the Second-Stage Recycle Bin (aka Site Collection Recycle Bin).

 

For my test site, it appears that if you use the above query with path

 

"/_api/site/RecycleBin"

 

 and filter on ItemState = 2, this corresponds to the Second-Stage Recycle Bin.

 

So the full query to get Second-Stage Recycle Bin that worked in my case is:

 

let
    SiteURL = "https://YOUR_TENANT.sharepoint.com/sites/YOUR_SITE",
    SharePointRecycleBin = OData.Feed(SiteURL & "/_api/site/RecycleBin"),
    #"ItemState 2" = Table.SelectRows(SharePointRecycleBin, each ([ItemState] = 2))
in
    #"ItemState 2"

 

This worked for me at least. I think technically the Second-Stage Recycle Bin exists per site collection rather than per site (in my case there is one site per collection anyway), so the query may vary when multiple sites are in one collection, but I'm not an expert on this aspect of SharePoint Online myself 😉

 

Does something like this work for you?