Integrating collibra and atlan to Power BI workspaces on the fly

[Anonymous]

Team,

We need to integrate Collibra and Atlan with Power BI. Whenever a user creates a workspace in Power BI, Collibra and Atlan should directly talk to Power BI and by default the service account for Collibra and Atlan should be dynamically added to the user access section under the Manage access tab of Workspace with a Viewer role. This is mainly to have enhanced governance feature for Power BI.

Please let me know your thoughts on this.

Regards

User

[Anonymous]

Hi @Anonymous ,

You can try the following:

Add-PowerBIWorkspaceUser (MicrosoftPowerBIMgmt.Workspaces) | Microsoft Learn

Install Power BI PowerShell Modules:

Install-Module -Name MicrosoftPowerBIMgmt

Connect to Power BI Service:

Connect-PowerBIServiceAccount

Create a PowerShell Script:

 ```powershell
   # Define variables
   $workspaceId = "your-workspace-id"  # Replace with your workspace ID
   $collibraServiceAccount = "collibra-service-account@yourdomain.com"  # Replace with Collibra service account email
   $atlanServiceAccount = "atlan-service-account@yourdomain.com"  # Replace with Atlan service account email

   # Add Collibra service account as Viewer
   Add-PowerBIWorkspaceUser -Id $workspaceId -UserPrincipalName $collibraServiceAccount -AccessRight Viewer

   # Add Atlan service account as Viewer
   Add-PowerBIWorkspaceUser -Id $workspaceId -UserPrincipalName $atlanServiceAccount -AccessRight Viewer
   ```

Save the script to a `.ps1` file and run it in PowerShell. Make sure you have the necessary permissions to add users to the workspace.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous]

Hi Neeko, Let me explain the requirement once again. Whenever any user in the organization having relevant access to Power BI logs in and creates a new workspace, service account of Collibra and Atlan should be directly associated with that workspace under the Manage Access tab with a viewer role. This all should happen dynamically. That means when I create a workspace,  by default the Atlan ID should be added to that workspace with a viewer role rather than me going manually and entering the user ID to the Manage Access section of Workspace and checking from the list of ids from AD and selecting the atlan ID. In your script I see that I need to specify a workspace which is not what I want to do. All this happens dynamically. Also for the Power BI account, I can use the Admin account to do this. But the workspace selection should be dynamic based on the ID (superuser).

Regards

User

[Anonymous]

@Poojara_D12  can you please provide me the steps to do the same as we dont have Azure Logic Apps in the organization. Do you have any code or any Power shell script that I can use for the same?

[Anonymous]

Hi @Anonymous ,

Whether the advice given by Poojara_D12  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Best Regards,

Neeko Tang

[Poojara_D12]

Hi @Anonymous 

To integrate Collibra and Atlan with Power BI for governance, you can automate the process using Power BI REST API. When a new workspace is created, use Power Automate or Azure Logic Apps to trigger the addition of Collibra and Atlan service accounts with a Viewer role. This can be done by calling the Add Group User API in Power BI. Make sure to sync governance policies between Collibra, Atlan, and Power BI to maintain proper access control.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS