Skip to main content

Row Level Security for Power BI/Onedrive Reports

There is a 2-step authentication for these 2 agents that requires a sign in validation from both Admins (Super Admin/Admins), and Users:

  • Admins must create a new instance and authenticate the login credentials.
  • Regular users must also log in to the agents and validate the credentials to access the reports.

Create Instance: Admin-level authentication#

Admin creates a new Power BI or Onedrive instance in the Agent Manager > Instance Manager screen by clicking Add Instance.

Authentication Pending

New PowerBI instance created

The initial Status of the instance will be "Yellow". This status indicates that Authentication is pending for the Agent.

  • Select the Instance and click Login As Admin.

    Login as Admin

    Login as Admin

  • In the pop-up window, enter the credentials of an account with administrative privileges:

    Power BI Administrator Login

  • Now the user will be authenticated successfully:

    Successful User Authentication

  • Power BI/Onedrive Agent is activated with a "Green" status.

    Instance Manager active

    Instance status activated

  • Go to Agent Manager, select Power BI/Onedrive agents and click Sync Users and Sync Reports.

note

If there is a mismatch in the platform user mapping and the user credentials, then the below authentication error will be shown:

Powerbi agent Login Credentials

Check the Microsoft Office login credentials for any other user log-in. You must log out the other user and sign in as your logged-in user credentials.