cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Missing User ID in table TenantOfficeLicenses from MS 365 Usage

Hi Guys,

 

Currently I am using MS 365 usage analytics. What I am struggeling with that in the most of the tables there are not User ID column.

 

For example in table UserState and UserActivity there is column UserID.

 

But I need this column (UserID) too in another tables, for instance in table TenantOfficeLicenses. 

 

The reason that I need this is beacuse I want to filter in my dashboard which user uses which licenses.

 

Thanks in advance!

 

3 ACCEPTED SOLUTIONS
Icey
Community Support
Community Support

Hi @Anonymous ,

 

Based on my test, it is suggested to export user table manually and add it into your model.license.JPG

license2.JPG

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

View solution in original post

Icey
Community Support
Community Support

Hi @Anonymous ,

 

Please check if this post could help you: Audit Logs for when the Users was assigned Power BI Pro License.

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

View solution in original post

Icey
Community Support
Community Support

Hi @Anonymous ,

 

Please check if this document is helpful: Track user activities in Power BI. It introduces several methods to obtain activity log.

And you can get sign-ins log in Azure Active Directory admin center:

aad.JPG

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

View solution in original post

5 REPLIES 5
Icey
Community Support
Community Support

Hi @Anonymous ,

 

Based on my test, it is suggested to export user table manually and add it into your model.license.JPG

license2.JPG

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

Anonymous
Not applicable

Hi Icey,

 

Thanks for your response! I have one more question. If is possible I want to get data about the activity of licenses/products ( for instance Visio, Power BI Pro etc.) of my users. 

 

So I want to know when a user enabled and activated a license for instance of Visio and when he used this product for last. 

 

Thank you so much!

 

Icey
Community Support
Community Support

Hi @Anonymous ,

 

Please check if this post could help you: Audit Logs for when the Users was assigned Power BI Pro License.

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

Anonymous
Not applicable

Hi @Icey ,

Thank for your response! In the you provided me I only see when a user is assigned to an product. This is not what I need, but I need to know when is a user was active on Power BI for instance.

I need the same information as below for the following products, Power BI, Office 365 F3, Microsoft PowerAutomate and Security E3

Aandeel_0-1607083862233.png

Thanks in advance!

Icey
Community Support
Community Support

Hi @Anonymous ,

 

Please check if this document is helpful: Track user activities in Power BI. It introduces several methods to obtain activity log.

And you can get sign-ins log in Azure Active Directory admin center:

aad.JPG

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it Out!

Join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors