cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Aandeel
Helper I
Helper I

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 @Aandeel ,

 

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 @Aandeel ,

 

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 @Aandeel ,

 

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 @Aandeel ,

 

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

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 @Aandeel ,

 

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

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 @Aandeel ,

 

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors