Power BI

The Power BI connector for rudol allows you to connect your Power BI instance and get your dashboards and reports in rudol.

Connection parameters

Name	Type	Description
Tenant ID	text	Service Principal Tenant ID
Client ID	text	Service Principal Client ID
Client Secret	password	Client Secret Key

How to create a user for Rudol on Power BI?

We recommend using a Service Principal. To create a Service Principal for Rudol you need to:

1. Create a new Service Principal App
2. Create a security group
3. Enable Power BI service admin settings
4. Add the Service Principal to your workspaces

Create a new Service Principal app

1. Login to your Azure Portal
2. Choose App Registrations
3. Click on New Registration
4. In the panel create a new registration for Rudol
5. After you click the Register button a new app is created and it will redirect you to the application page. Here you will find your Client ID and Tenant ID.
6. On the left menu click on Certificates & Secrets tab
7. Click on New Client Secret
8. Once the secret is created, copy the value, that will be your Client Secret

After completing this you will have your connection parameters ready.

Create a Security Group

1. Login to Microsoft Entra
2. On the left open the Identity panel
3. Click on Groups > All groups
4. Click on New Group
5. Fill the group type and name and click on create
6. Click on the new security group you created and click on Members tab to add the Service Principal to this group.
7. Add the Service Principal you created in the previous section as a member of the security group.

Grant access of PowerBI to the security group

1. Go to your PowerBI website and go to the admin portal
2. Under Tenant Settings go to Developer Settings.
3. Go to Allow service principals to user Power BI APIs and click on Enabled
4. Under Apply to select "Specific security groups" and add the security group you created in the previous section.
5. Also go to the Admin API settings to enable the service principals to use the admin APIs, enhanced metadata and expressions. Please expand all the panels and enable them, give the security group access to all three of them.

Add the service principal to your workspaces

1. Go to your PowerBI website
2. Move to the workspace you want to give access to, click on the 3 dots and click on Access Settings
3. On the Access Panel add the security group you created before

You need to repeat these steps for every workspace you want to add to Rudol.