Power BI users added

[Wessel de Jongh]

I am using the Power BI extension and the app itself to get an insight to data within my Jira projects. One of the things I want to get insight in is the amount of people that joined the company since Q1 last year and the total amount of employees.

Now I am a bit stuck on how to measure the amount of people that joined since Q1 last year. For the total amount of employees I just load all the users and filter out the Atlassian made "users" from the our real employees. Now this doesn't help for my other problem as the user data doesn't include when they were added (at least not that I know of). The other way I was trying to make it work was via the audit log. This includes exactly the date and time when a user was created and Power BI can also extract that data. However the audit log doesn't extend further than 6 months. So either I have when users were created but not of a long enough time period or I have all users, but not the time when they were added/created.

What would be a way to still get this data? Is there maybe an option within the audit log or a data field that I missed within the Power BI extension? The Power BI data does include long avatar url and user account ID. Maybe that there is some data on when the user was created/added hidden in there?

For more details, I use the "Power BI Connector for Jira" extension. These pictures are part of the ERD diagram of the data that I am sending to Power BI:

[Marc - Devoteam]

Hi @Wessel de Jongh 

Unfortunate there is no other setting and the audit log retention can't be set to longer then 6 months.

If you do want to retain this, you can get the audit logs via the API and keep this information stored on a location outside Jira.

Then you should be able to use this in PowerBI

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-audit-records/#api-rest-api-3-auditing-record-get 

See form more information; audit-activities-in-jira-applications 

[Wessel de Jongh]

Hey @Marc - Devoteam 

Thanks for the help! I went through some API documentation and came across this:

API documentation 

Looking at what data is available I saw "addedToOrg". Could this be exactly what I am looking for? 

[Marc - Devoteam]

Hi @Wessel de Jongh 

This could be, trying is the option to see if this is the correct information you are looking for.

Please accept my answer as a solution, if my answer helped to solve your request.

This will help other community member trying to solve the same.

P.S. If the answer is very valuable to you, please share some kudos.