Sharepoint usage

[rachoksh]

How can I find unused SharePoint online site collections that have been abandoned for more than 6 months?

Can O365 Content pack for Power BI help me with this?

Thanks

[v-yuezhe-msft]

@rachoksh,

You can use the PBIT file of O365 adoption Content Pack in Power BI Desktop, then calculate the count of sites that have been abandoned for more than 6 months by evaluating the date field in SharePoint site tables.

Regards,

[rachoksh]

I downloaded the Power BI Desktop and installed it. I was also able to use my tenant ID to make the connection. Can you please help me with steps to find the unused sites? Thanks

[v-yuezhe-msft]

@rachoksh,

Create measure using the DAX below and check if it returns your expected result.

Measure = CALCULATE(SUM('TenantSharePoint-Usage'[TotalSites]), FILTER('TenantSharePoint-Usage', (TODAY()-'TenantSharePoint-Usage'[ContentDate])>180))

Regards,
Lydia

[rachoksh]

Unfortunaltely, I am new user but opened file Office365 Adoption_PublicPreview05222017.pbit in PowerBI Desktop and entered my Azure AD GUID. But still needs steps to create the new measure/report using the query you suggested.

Thanks

[v-yuezhe-msft]

@rachoksh,

Right click the 'TenantSharePoint-Usage' table in Fields panel and select “New measure”, and add the following DAX.

Measure = CALCULATE(SUM('TenantSharePoint-Usage'[TotalSites]), FILTER('TenantSharePoint-Usage', (TODAY()-'TenantSharePoint-Usage'[ContentDate])>180))

Regards,

[rachoksh]

I get the same results even after changing the number from 180 to 7 or 360. I know for sure I have some sites that have not been used in months.

 

[v-yuezhe-msft]

@rachoksh,

Create a measure using the DAX below to check the minimum date in your table, maybe the minimum date is within 7/180 days.

MinDate = MIN('TenantSharePoint-Usage'[ContentDate])

Regards,
Lydia

[rachoksh]

Still the same output - 

[v-yuezhe-msft]

@rachoksh,

What is the result does the measure return?

Regards,
Lydia

[rachoksh]

How do I get result for just his measure? Sorry for the delay.

[v-yuezhe-msft]

@rachoksh,

Drag the measure to a Card visual.

Regards,

[rachoksh]

How can I use O365 Content Pack for Power BI to find unused SharePoint Online site collections that have been abandoned for more than 6 months?

Thanks