Often as admins, there would be a need to generate various site usage and analytic reports from SharePoint and Microsoft 365 admin center provides a robust reporting center to generate reports from various services. If we head over to the admin center and navigate to Reports ->Usage, we can view the various reports in the window.
We can select SharePoint Specific reports to view the usage details. We can click on the export button for it to generate a CSV report of the details which we can download.
Unfortunately, the generated report has the Site URL and Owner display name hashed out with anonymous text.
The problem intensifies when we are using PowerShell and Graph API to get the usage details of the site and loop through each site to do some operations where we will need to create a site object and the Site URL field has some concealed text which cannot be used for any scripting purposes.
A detailed scenario of using PowerShell to get the SharePoint Site usage details and further processing using the data is described here. I stumbled upon the issue while working with the PowerShell script as it was a showstopper as the URL is masked.
This had been a recent change Microsoft had made starting September 1st, 2021, where they are hiding user information by default for all reports as part of supporting companies to abide by their local privacy laws.
To fix this issue, we can do a bit of change in the configuration setting in the Microsoft 365 Admin center. Let’s head over to the settings -> Org Settings -> Services. Select the Reports option.
It will open up the right pane where we can uncheck “Display concealed user, group and site names in all reports”. This setting applies to Microsoft 365 usage reports in Microsoft 365 admin center, Microsoft Graph and Power BI, and the usage report in Microsoft Teams admin center.
Now we can try out getting the usage details by running the PowerShell script to get the site usage details and we can see that the concealed data is now being shown with proper data.
In the same way we can export the report from the UI and see the Site URL and Owner details without being concealed with random data.