Quick Tip: View the Power BI Adoption content pack for Office 365 in Microsoft Teams


In the last Quick Tip, we looked at how to send the weekly Message Center email to Microsoft Teams. This Quick Tip is also related to Teams - maybe I need to start calling them "Teams Tips"...

Anyway, hopefully you heard or read that last week we announced the public preview of the Office 365 adoption content pack in Power BI. This post will walk you through pulling this insightful information into Microsoft Teams!

 

Two approaches are detailed in this post:

  1. Individual user sharing the adoption report with a Team
  2. Enabling the adoption content from within the Team

 

For both approaches, you will need the following to enable the content pack:

 

Individual user sharing the adoption report with a Team

First, I need to enable the adoption content pack.

If you don't already have Power BI, the link provides instructions on how to sign up for the free version, which is all that is required for individual access.

Note: The user who connected to the content pack can share the content pack by using the sharing functionality. Power BI licensing requires that both the user sharing and the user with whom a dashboard is shared have Power BI Pro or Power BI Premium licenses, which also applies to setting this up in Microsoft Teams.

As noted in the enable steps linked above, the data collection can take between 2 and 48 hours, depending on the size of the tenant.  It took less than an hour for my tenant - but it only has 25 accounts, so your mileage may vary.

Once the enablement of the adoption content pack has been completed, I can now proceed with adding this into Microsoft Teams…

I'm using the Teams desktop client, so I open the client and go to the Team where I want to add the adoption content.  In this case, I have a dedicated "Reporting" channel in the Team which is where I want to pull in the adoption data. I click the '+' to add a tab and choose "Power BI" from the apps list.

 

teams-adoption-pack-10

 

I rename the tab and since I'm sharing the report in this scenario, I confirm that "Workspace" is set to "My workspace" which is the default location when enabling the content pack in Power BI. I then select "Office 365 Adoption Preview" as the report to show in this tab. If you leave "Post to the channel about this tab" checked, which it is by default, then a message will be posted to the channel notifying the team a new tab has been added to the channel. Click "Save" to add the tab.

 

teams-adoption-pack-13

 

I'm logged in with the same account I enabled the content pack with and it also has a Power BI Pro license assigned, so the data is now displayed in the Teams tab as shown below:

 

teams-adoption-pack-19

 

And, that’s all there is to it for an individual to share a Power BI report in Microsoft Teams.  Now on to the second approach…

 

 

Enabling the adoption content pack from within the Team

With this approach, I still need to enable the adoption content pack, but the process is different than what was used for the individual user.

Since the account I used above is a member of the Team I want to add the adoption content to, I log into Power BI and go to "Workspaces" and choose the team where I want to pull in the adoption content.

 

teams-adoption-pack-18

 

I then get a prompt informing me that Power BI Pro is required for Groups/Teams, so I complete the free trial process to allow me to move forward. If you have Power BI Pro or Premium licenses, then you can assign a license to the account you're using and the prompts should not be displayed.

 

teams-adoption-pack-01          teams-adoption-pack-02          teams-adoption-pack-03

 

Once I have the appropriate license assigned, I can proceed by selecting Get under Microsoft AppSource > Services.

 

teams-adoption-pack-05

 

I then search for "adoption" and see "Office 365 Adoption Preview", then click "Get it now".

 

teams-adoption-pack-06

 

I enter my tenant ID when prompted and when the window below is displayed, I make sure "Authentication method" is set to "OAuth2", before I click "Sign In":

 

teams-adoption-pack-07

 

An "Importing data" pop-up appears in the upper right-hand corner of the Power BI dashboard:

 

teams-adoption-pack-08

 

Reminder: the data collection can take between 2 and 48 hours, depending on the size of the tenant

 

Once the "Your dataset is ready!" message is displayed in Power BI, I go back to the Teams client to add the adoption content to the Reporting channel. I click on the ‘+’ to add a new tab and then select “Power BI”.

 

teams-adoption-pack-10

 

I rename the tab and since I want to pull in the report linked to the Team, I confirm that "Workspace" is set to the Team name, “Cloud Central" in this example. I then select "Office 365 Adoption Preview" as the report to show in this tab. If you leave "Post to the channel about this tab" checked, which it is by default, then a message will be posted to the channel notifying the team a new tab has been added to the channel. Click "Save" to add the tab.

 

With a different account, I log into Teams via the web client to verify I am able to view the adoption content.  Note: For this account, I had to complete the same Power BI Pro for Groups trial process as outlined above when first enabling the content pack.

 

teams-adoption-pack-20

Note: There are numerous tabs in the report as circled in green in the above screenshot.

 

Now, all members of the team can view the adoption data directly in Microsoft Teams!

 

Power BI Adoption content pack for Office 365 resources:

 

Microsoft Teams resources:

 

Comments (2)

  1. Agust J says:

    How can I get my tenant fixt so that the Office365 Adoption pack is visible to me. I get 404 error when I try to open the Service->Get button in Power BI. I follow the Reports->Usage->Office365 Adoption path to open Power BI. I use my Global Admin in my portal

    1. Hello Agust J,

      The Troubleshoot Office 365 Adoption content pack article has the following reference for a 404 error:

      The tenant ID you provided is not recognized by our system

      Error Code: 404

      Where you will see this message: In Power BI when you are connecting to the Office 365 Adoption public preview content pack or when directly calling the Office 365 Reporting APIs.

      Cause: The tenant id you provided is not valid or does not exist.

      To fix this error: Go to the Office 365 admin center >Reports >Usage and locate the Office 365 Adoption tile on the main dashboard page. The tenant id is listed on the tile. You can copy it from here and paste it in the dialog box for connecting to the content pack.

      Regards,
      Thomas

Skip to main content