cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rachoksh Frequent Visitor
Frequent Visitor

Sharepoint usage

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

 

12 REPLIES 12
rachoksh Frequent Visitor
Frequent Visitor

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

Moderator v-yuezhe-msft
Moderator

Re: Sharepoint usage

@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,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rachoksh Frequent Visitor
Frequent Visitor

Re: Sharepoint usage

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

Moderator v-yuezhe-msft
Moderator

Re: Sharepoint usage

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rachoksh Frequent Visitor
Frequent Visitor

Re: Sharepoint usage

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

Moderator v-yuezhe-msft
Moderator

Re: Sharepoint usage

@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))


1.PNG2.PNG


Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rachoksh Frequent Visitor
Frequent Visitor

Re: Sharepoint usage

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.

 PBI_report.png

 

 

Moderator v-yuezhe-msft
Moderator

Re: Sharepoint usage

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rachoksh Frequent Visitor
Frequent Visitor

Re: Sharepoint usage

Still the same output - Smiley Sad

PBI_report2.png

 

 

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 315 members 2,909 guests
Please welcome our newest community members: