Find users who have signed in

If you're an admin for your organization, and want to see who has signed into Fabric, use Microsoft Entra access and usage reports, which are also known as the sign-in logs.

Note

The Sign-in logs report provides useful information, but it doesn't identify the type of license for each user. Use the Microsoft 365 admin center to view licenses.

Requirements

Any user can view a report of their own sign-ins. To see a report for all users, you must be in one of the following roles: Global Administrator, Security Administrator, Security Reader, Global Reader, or Report Reader.

Use the Microsoft Entra admin center to view sign-ins

To view sign-in activity, follow these steps:

  1. Sign in to the Microsoft Entra admin center, and then select Microsoft Entra ID from the portal menu.

  2. From the resource menu, select Monitoring > Sign-in logs.

    Screenshot of the Microsoft Entra admin center with Sign-in options highlighted.

  3. By default, all sign-ins from the last 24 hours for all users and all applications are shown. To select a different time period, select Date in the working pane and choose from the available time intervals. Only information from the last seven days is available. To see only sign-ins to Power BI, add filters:

    a. Select Add filter > pick Application as the field to filter by, and select Apply.

    b. From the top of the working pane, select Application contains.

    • To see only sign-in activity that's related to Power BI, enter Microsoft Power BI

    • To see only sign-in activity that's specific to the on-premises data gateway, enter Power BI Gateway

  4. Select Apply.

Microsoft Power BI filters to sign-in activity related to the service. Power BI Gateway filters to sign-in activity specific to the on-premises data gateway. Screenshot of the Sign-in filter with the Application field highlighted.

Export the data

You can download a sign-in report in either of two formats: a CSV file, or a JSON file. Use the following steps to download your report:

  1. From the command bar for the Sign-in logs report, select Download and then select one of the following options:

    • Download JSON to download a JSON file for the currently filtered data

    • Download CSV to download a CSV file for the currently filtered data

  2. Decide what type of sign-ins you want to export, and then select Download.

    Screenshot of the data export with the Download option highlighted.

Data retention

Sign-in-related data is available for up to seven days, unless your organization has a Microsoft Entra ID P1 or P2 license. If you use Microsoft Entra ID P1 or Microsoft Entra ID P2, you can see data for the past 30 days. For more information, see How long does Microsoft Entra ID store reporting data?.