Find Power BI users that have signed in
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.
This activity report includes both Power BI (Free) and Pro users but does not identify them by which license they have.
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.
- Browse to the Azure portal and select Azure Active Directory.
Under Activity, select Sign-ins.
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 whereas 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.
Within the Activity screen, you can select Download in the toolbar. This will download a csv file for the currently filtered data.
You can use PowerShell to export the sign-in data. A sample is available within the Azure AD documentation.
For the PowerShell sample to work, be sure to follow the prerequisites to access the Azure AD reporting API.
Sign-in related data can be available for up to 30 days. For more information, see Azure Active Directory report retention policies.
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