topic Re: How to get assignment date for Power BI Pro license using API? in Developer

How to get assignment date for Power BI Pro license using API?

Anonymous — Mon, 13 Mar 2023 12:28:07 GMT

I need a list of pro user with detail about when user has been assigned Pro license? Can we somehow fetch this data using API or Power Shell Cmd?

I searched in Auditlog data but no such activity has captured in logs. I need this kind of data to check after how many days acquiring pro license, user has started performing Pro activity in Power BI.

Any help would be appreciated.

Re: How to get assignment date for Power BI Pro license using API?

v-jianboli-msft — Wed, 15 Mar 2023 02:25:52 GMT

Hi @Anonymous ,

You can check the assignment date via the Azure AD PowerShell module.

Besides, Microsoft Graph API and M365 Admin portal may also help you.

Here are some links about this, hope they could give you some help:

See the assignment date of a license - Microsoft Community Hub

How to find all Power BI users in an organisation?

Retrieve Power BI Pro Licensed Users

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How to get assignment date for Power BI Pro license using API?

Anonymous — Wed, 15 Mar 2023 06:31:21 GMT

Thank you for sharing this,

But I am unable to fetch data specific to Power BI Pro license using command mentioned in article.

I am working as Power BI admin and should know when user been assigned Pro license. Is there any way I can get this data?

Re: How to get assignment date for Power BI Pro license using API?

Adamboer — Wed, 15 Mar 2023 13:04:30 GMT

Unfortunately, it is not possible to get the exact date and time when a Pro license was assigned to a user via API or PowerShell cmdlet. This information is not stored in the audit log data, which is the primary source for such activity tracking in Power BI.

However, there are a couple of ways you can get a rough estimate of when a user was assigned a Pro license. One way is to check the license assignment activity in the Microsoft 365 admin center, which logs the date and time when a license was assigned to a user. Another way is to check the user's activity in Power BI and see when they started performing Pro activities. This will give you an idea of when they might have been assigned a Pro license.

I hope this helps. Please let me know if you have any further questions or concerns.