Have you seen rich analytics locked in your Office 365 tenant? Here is how to enable and access them


How many new vs. returning users? Which content did they access? and when?

These and many more answers are available at your fingertips if you know how to access them. With those you could easily build a story around how people are using your intranet and demonstrate the value it has for your organization.

So how do you enable these fabulous reports?

1. Log into Admin Portal with Tenant Administrator username and password: https://portal.office.com/AdminPortal/Home

2. In the left hand panel click [Reports] -> [Usage]

3. Scroll down to the page to see [Office 365 Adoption (Preview)], as shown below.

At first you will need to click on the card and chose [Make data available to the Office 365 Adoption content pack for Power BI] to [ON] ... click [SAVE]

This can take few hours (for large tenants especially, can take 2 days as Microsoft says) so you'll want to check back again and see when you get [Office 365 Adoption (Preview)] to show you the button saying [Go to Power BI] as you can see below.


That part where I have [redacted] in the screenshot, is the ID you will need to copy for our next steps.

4. Click [Go to Power BI] and when prompted to [Sign In] click on it. Since this functionality is still in preview you may get few more "consent" screens but eventually you'll land on this one ... asking you to [Add a Service], follow as shown below

adding service.gif

5. Now this is where you will be prompted to enter that ID you copied earlier in step 3 where I had it "redacted"

6. Once entered click [NEXT] and on the following screen click [SIGN IN]. You'll be once again prompted to confirm your Tenant Admin account.

7. Next you may need to wait few minutes while data import has completed. When it has you'll know by the [Office 365 Adoption Preview] button showing as active as opposed to greyed out as shown below:


Once enabled, click on the button to load all of the dashboards. In my case it took another minute for dashboards to populate so if it does for you - that's normal, no need to refresh the page.

From here you are free to navigate around to discover all there is.

For SharePoint specific data

Click [Adoption Overview] chart and select [SharePoint] from the list of available products to chose from. 

You may also use navigation at the bottom to drill down to specific SharePoint metrics.

sharepoint analytics.PNG

How did you find PowerBI analytics? Did you find insights you were looking for?


Yaroslav Pentsarskyy is the founder of OrigamiConnect, a rapidly growing service and product offering which enables organizations to get an intranet designed for them without starting from a blank page. He's also 8 time Microsoft MVP, speaker at many local and worldwide tech events, and a published author of several SharePoint related books.