Skip to main content

ETL user synchronisation logic

Overview​

This feature ensures that all users who have access to at least one report in Power BI can log in to the Hub (i.e., are not blocked).

Synchronization is based on Auditor (ETL) data and reflects the user access state as of the current date.

Initial Activation​

When an administrator enables:

  • Sync user permissions
  • Unblock the users if they have any access

The system performs the following actions:

  1. Retrieves all users who have access to at least one report in Power BI as of the current date.
  2. Compares them with users on the Hub.
  3. If a user has access to at least one report and is blocked on the Hub, the system automatically unblocks the user.

Example:

If synchronization is enabled on December 30, the system evaluates all users who have access to any report on December 30 and unblocks them if necessary.

Nightly Synchronization​

Every night, the system:

  1. Compares users from ETL (Auditor data) with users on the Hub.
  2. Checks for:
    • New users with access to at least one report.
    • Users who are currently blocked on the Hub but have valid access.

If a user:

  • Has access to at least one report on the current date.
  • Is blocked on the Hub.

The system automatically unblocks the user.

User Removal from Source System​

If a user:

  • Had access to a report on a previous date.
  • Does not have access as of the current date.

Then:

  • The user account status on the Hub is not changed.
  • The license is not removed.
  • If the user is active, they remain active.

This feature supports automatic unblocking only. It does not automatically block or deactivate users.

Behavior When Settings Are Disabled​

If "Unblock the users if they have any access" is disabled:

  • The system does not change user account statuses.
  • Active or blocked states remain unchanged, regardless of report access in the source system.

If "Sync user permissions" is disabled:

  • No permission or account state synchronization is performed.
  • No user account status changes are applied.