If you are a tenant admin, and want to see who has signed into Power BI, you can use the Azure Active Directory access and usage reports to gain visibility.

You can access the activity report within the new and the classic Azure Active Directory (Azure AD) portals. While the video above uses the classic portal as an example, this article will highlight the new portal.

Note:

This activity report includes both Power BI (Free) and Pro users but does not identify them by which license they have.

Requirements

The following are requirements to view the sign-in activity report.

  • Users in the Global Admin, Security Admin or Security Reader role can access the access the data.
  • Any user (non-admins) can access their own sign-ins.
  • Your tenant must have an Azure AD Premium license associated with it to see the all up sign-in activity report.

Using the Azure portal to view sign-ins

You can use the Azure AD portal to view sign-in activity.

  1. Browse to the Azure portal and select Azure Active Directory.

  2. Under Activity, select Sign-ins.

  3. Filter the application by either Microsoft Power BI or Power BI Gateway and select Apply.

    Microsoft Power BI is for sign-in activity related to the service where as Power BI Gateway are specific sign-ins for the On-Premises Data Gateway.

Export the data

You have two options to export the sign-in data. This can be done by either downloading a csv file or you can use PowerShell.

Download csv

Within the Activity screen, you can select Download in the toolbar. This will download a csv file for the currently filtered data.

PowerShell

You can use PowerShell to export the sign-in data. A sample is available within the Azure AD documentation.

Note:

For the PowerShell sample to work, be sure to follow the pre-requisites to access the Azure AD reporting API.

Data retention

Sign-in related data can be available for up to 30 days. For more information, see Azure Active Directory report retention policies.

Next steps

Sign-in activity reports in the Azure Active Directory portal (New Portal)
View your access and usage reports (Classic Portal)
Sign-in sample PowerShell script
Azure Active Directory report retention policies
Using auditing within your organization
Extended Pro Trial activation

More questions? Try asking the Power BI Community