Forum Discussion

rachoksh's avatar
rachoksh
Regular Visitor
9 years ago

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

  • rachoksh's avatar
    rachoksh
    Regular Visitor
    9 years ago

    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

    • rachoksh's avatar
      rachoksh
      Regular Visitor
      9 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        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