Home

Office 365 Adoption Content Pack in PowerBI

33 Conversations

Latest Activity

Custom List Message Item

We are using Teams in our company, and would like to have reports about Teams adoption.

Is it coming in a future version of the adoption pack and when?

 

Thanks!

673 Views
8 Replies

Yeap, this is something that will be added to the Adoption Content Pack, but not ETA yet

Best Response confirmed by Olivier Tran (New Contributor)

Hi,


Currently we download all the O365 reports from the Admin centre and customize a PowerBi report on how each application is being used, we use a combination of our customised report and the Adoption content pack. However, there are no reports that I can

... Read More
112 Views
1 Reply

Hi Shaun,

we're exploring to add a report on PowerBI usage at a future point but don't have an ETA to share yet.

Thanks,

Anne

One of my clients is starting to use the adoption pack.  Until recently the main user was a Global Admin, however in order to start bring some semblence of control to the tenant, we have been locking down accounts. As a result, we've changed this user to

... Read More
304 Views
12 Replies

Hi Paul,

please ask your customer to open a support ticket so that we can look into this.

Thanks,

Anne

Dear all,

I work as an Adoption consultant and this dashboard can be a great tool. I want to create a Adoption dashboard, the content pack is a great start. However, I want to customize the dashboard. I have read that only the admin can customize. My quest

... Read More
104 Views
2 Replies
If you have a Power BI Pro license in your tenant, you should be able to customize...and better than customize it, you could use the underlying Power BI Model to build yo... Read More

Hi all,

 

Currently finding the Adoption pack to be very helpful but I'd like to be able to separate my internal users out of the adoption metrics. How would you be able to do this? We can separate our users based on the "LocationOffice" field under user ac

... Read More
76 Views
1 Reply

Hi Oscar,

the tenant datasets are precomputed monthly aggregate data sets that do not offer the ability to drill in by user metadata. We only bring in user level data for

... Read More

Hi,

Working on what makes sense for us to monitor adoption of Office 365 services, we'd really want some statistics about how many files people are sharing using outlook compared to onedrive sharepoint, and how it is evolving in time. We are pushing people

... Read More
128 Views
2 Replies

Hi Stephane,

such a report is currently not available, but we're looking how to bring this information to our customers in the future. We'll share more information in the

... Read More

Hi, please advise ... i have quickly had a look at the dataset of the o365 adoption content pack and i'm missing a critical set of stats for Project Online ... are the stats skewered within the Sharepoint stats; or is there a separate table with ProjectOn

... Read More
75 Views
1 Reply

Sadly all the project online, team sites, group sites are treated as SharePoint data in o365 adoption content pack as well as in unified audit log. MS didn't provide any

... Read More

I need to be able to report on users who have not been active for more than 180 days. I also need to drill down to be able to list the individual users and their last activity date.

 

How can this be achieved?

163 Views
4 Replies

Hi Julian,

 

There are various powershell scripts about. I'm currently browsing for one which looks trustworthy. It amazes me that there isn't a standard report in 365 to s

... Read More

Last few days I have been getting this error and wondering how I may solve it.

 

Data source error:Column 'UserId' in Table 'UserActivity' contains a duplicate value '159FF9DCDA02493C50737375F7C2CA22' and this is not allowed for columns on the one side of a
... Read More
130 Views
3 Replies
We are aware of this issue and will be rolling out a fix to this issue very soon

First step is to find the offending userID.  Here is how I found it.

Click on the Office 365 Adoption Preview (DATASET).

On the right under "Fields", find and expand the ta

... Read More
Same here. any way to fix would be great!

The Yammer User activity reports are almost useless to us since a single user is having read 30x more posts than the second. It has increased from roughly 5 000 reads a week or two ago to 30 000 reads today, and he has a very typical Yammer behavior. With

... Read More
115 Views
2 Replies
we had the same strange thing :)

As a follow-up, a few months later the data in the Yammer User Activity report looks more "normal". No outliers any more.

Im currently building my own dashboards, but I dont really get the difference between these 3 user types.

 

Can someone explain what active/enabled/total users mean?

 

Ty in advance.

111 Views
2 Replies

Hi Marco,

let me use OneDrive as an example:

Total users: all Office 365 users in your company

Enabled users: Anybody who has been assigned with a OneDrive license

Active

... Read More

Hi,

 

Is it possible to see how many times a item in a list is viewed?

 

Regards

Stefan

62 Views
3 Replies
You will probably need to wait for the SharePoint framework extensions that are in preview. You can then add tracking code in the header of the pages. Haven't tried it ye... Read More
The SharePoint usage report in the admin center includes site views now but you can't see view information for individual items.
Quite sure this is not possible with the Content Pack (at least in the Dashboard and reports provided)...have you taken a look at the audit features you have at the Compl... Read More

Just started working with the Ofice 365 Adoption Preview Pack. Under reports, several reports are showing last month's data. How do I change it to show a different month? 

129 Views
4 Replies
Hi Jeff, the adoption content pack shows data for two different timeframes: The majority of the reports display data for the previous 12 months. However, some of the char... Read More
Same issue here, can only evaluate the data of last month.
I haven't look recently, but at the time the data that was being pulled from MS was hard set for that period only.

Hi Jeff, did you find a solution to change the date ? Is it possible to view results for the previous months ? Thx

My colleage and I are new to Power Bi but have worked in Office 365 and migrations for a few years. We have been working with the O365 Adoption pack for about a week, pulling data from O365 using the ODATA connector, but we are not finding specific fields

... Read More
111 Views
1 Reply
What you can use is the Power BI Adoption Content Pack Dashboards and reports + also the underlying data model...in case this is not enough for you, then you should try t... Read More

Is there a way to filter for location (eg Country, City) across the different report tabs (eg the Onedrive for Business Usage tab)?

 

The use case is that I'm trying to establish trends across several months for ODB and SP usage for specific countries to be

... Read More
121 Views
3 Replies
Sorry, month + user data works, but only for the last complete month it seems.
I have tried to use the country attribute in the data set in various ways but it seems to not play with the tenant info, only user data. I can't figure out how to combine... Read More

Yammer Usage:

1. How should avg count be interpretted?

Yammer_Usage.PNG

 

Exchange Usage:

2. We have not migrated to EXO, how could 8 mailbox contributed to 37.50%?

Exchange_Usage.PNG

Read More
75 Views
2 Replies
Hi Swu, please take a look at the following support documentation and let me know if you still have questions: https://support.office.com/en-us/article/Active-user-in-Office-365-usage-reports-093a6d0d-890b-489e-9f46-b15687d3fe4f Read More

Yammer User:

3. How do we interpret a total active Yammer user in a month? 258 (active) + 143 (returning) + 41 (first time) ?

Yammer_User.PNG

Read More

7-18-2017 7-27-35 AM.pngSo I've enabled Office 365 Adoption - it stated your date is ready. Go to power BI to view reports, I click on "Go to Power BI" but it is all greek to me at this point. See above, what ever I click on takes me to nothing. What should I be doing to see dat

... Read More
258 Views
2 Replies

Here is they error when I tried to add: Office 365 Adoption Preview

 

We couldn't import data from Office 365 Adoption Preview.

There was an error when processing the data i

... Read More

The FAQ references a Power BI Template file (.pbit) so that the reports can be accessed in Power BI Desktop, however, I can't seem to find the file anywhere. Has it been published, and if so, where can I download it from? Apologies if I'm being daft and m

... Read More
804 Views
7 Replies

Here is the download https://go.microsoft.com/fwlink/?linkid=849814

 

Not easy to find.

Read More

Hi Samuel,

 

I didn't find the file either, but I followed the steps on this page to connect manually with PowerBI Desktop:

https://support.office.com/en-us/article/Enable-the-Power-BI-adoption-content-pack-for-Office-365-9db96e9f-a622-4d5d-b134-09dcace55b6a?ui=en-US&rs=en-US&ad=US

... Read More

how is the security handled for the dashboard?  Is it locked down to the administrator by default and whomever gets a sharing link will have access?

62 Views
1 Reply

anyone? Has anyone deployed it?

I don't get how I can see user adoption by department or user activity. Everything else is populated but these reports show blanks.

Is it not really enabled in the preview?

Thanks!

311 Views
16 Replies

Yeap, seeing the same @Anne Michels FYI

Hi Guys,

 

I was previously working in the adoption content and this was working fine.

 

I removed the report as it was not updating and i was going to add it back in.

 

However, after typing in my tenant ID it now says that the credentials provided are invalid

... Read More
145 Views
3 Replies

I too have this problem all of a sudden and can't find anything that matches online as of yet. I'm hesitant to put in a ticket from an Office 365 tenant only to be referr

... Read More

Hi,

Apart from the Sharer and Consumer both having PowerBI Pro or Premium licencess, is there another simple way to share the contents of the adoption pack to non-admins?

 

Thanks,

Simon

283 Views
7 Replies

Simon your query is not clear. What do you mean by " is there another simple way to share the contents of the adoption pack to non-admins"

 

You can just share the report

... Read More

It will be good to have Power BI desktop installation as part of ODT.

71 Views
0 Reply

When I activated the Office 365 Adoption Content Pack, it automatically saved in the "System Center" workspace.

 

Can I move it to another workspace?

57 Views
0 Reply
1. How information is captured on Power BI - what is the method in which data is imported (API/ excel data import)? We need a walkthrough of this how it's done 2. Can we have access for master data or raw data? Do we have the profile/ AD details in the m... Read More
198 Views
1 Reply

There's no question that the new adoption pack serves as a useful tool. However; based on the questions you are asking, it seems like you can benefit from for more detail

... Read More