Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anotny
Frequent Visitor

Create Groups in Azure AD and apply security to power bi dataset

Hello,

I am working on managing access for power bi datasets security. In order to implement RLS, first I want to create 2 groups in Azure AD and then add those groups inside power bi security RLS.

 

Could you please guide me or help with resources to create groups for members in azure and add those groups to power bi dataset security.

1 ACCEPTED SOLUTION
v-heq-msft
Community Support
Community Support

Hi Anotny,

 

To create groups in Azure AD and apply security to Power BI datasets, here are some of my completed steps that you can follow to create them.

First, please create groups in Azure AD

 

  1. Go to the Azure portal(https://portal.azure.com) and sign in with an account that has the necessary permissions to create groups.
  2. On the home page, choose left-hand side, select “Microsoft Entra ID” from the services list.

vheqmsft_0-1700556732135.png

     3.In the Microsoft Entra ID pane, select “Groups

vheqmsft_1-1700556732135.png

     Click on “New group

1.png

     4.Fill in group details:

  • Group type: Select “Security”.
  • Group name: Enter a name for your group.
  • Group description: Provide a description (optional).
  • Membership type: Choose either “Assigned” or “Dynamic User” depending on how you want to manage membership.

3.png

     5.Add members:

  • Click on “No members selected” to add members to the group.
  • Search for and select the users you want to add.
  • Click “Select” then “Create”. 

4.png

   6.Repeat steps 3 to 5 for the second group. 

5.png

Adding Azure AD Groups to Power BI Dataset Security

 

  1. Go to Power BI Service (https://app.powerbi.com) and sign in.
  2. In the workspace where your dataset is located, click on ”Datasets”. 6.png

     3. Find the dataset you want to apply RLS to and click on the “More options(...)” button.

Select “Security”.

7.png

 

4.Apply RLS to the groups:

  • In the RLS pane, click on “Add”.
  • Search for the Azure AD groups you created earlier.
  • Select the group and assign the appropriate roles.
  • Click “Save” to apply the changes.

8.png

 

By following these steps, you Can created two security groups in Azure AD and applied them to your Power BI dataset security for implementing Row-Level Security (RLS).

For more detailed information, you can refer to the following documentation:

Create a new group in Azure Active Directory

(https://docs.microsoft.com/en-us/azure/active-directory/fundamentals/active-directory-groups-create-...)

Row-level security (RLS) with Power BI

(https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls)

 

Best Regards,

Albert He

View solution in original post

1 REPLY 1
v-heq-msft
Community Support
Community Support

Hi Anotny,

 

To create groups in Azure AD and apply security to Power BI datasets, here are some of my completed steps that you can follow to create them.

First, please create groups in Azure AD

 

  1. Go to the Azure portal(https://portal.azure.com) and sign in with an account that has the necessary permissions to create groups.
  2. On the home page, choose left-hand side, select “Microsoft Entra ID” from the services list.

vheqmsft_0-1700556732135.png

     3.In the Microsoft Entra ID pane, select “Groups

vheqmsft_1-1700556732135.png

     Click on “New group

1.png

     4.Fill in group details:

  • Group type: Select “Security”.
  • Group name: Enter a name for your group.
  • Group description: Provide a description (optional).
  • Membership type: Choose either “Assigned” or “Dynamic User” depending on how you want to manage membership.

3.png

     5.Add members:

  • Click on “No members selected” to add members to the group.
  • Search for and select the users you want to add.
  • Click “Select” then “Create”. 

4.png

   6.Repeat steps 3 to 5 for the second group. 

5.png

Adding Azure AD Groups to Power BI Dataset Security

 

  1. Go to Power BI Service (https://app.powerbi.com) and sign in.
  2. In the workspace where your dataset is located, click on ”Datasets”. 6.png

     3. Find the dataset you want to apply RLS to and click on the “More options(...)” button.

Select “Security”.

7.png

 

4.Apply RLS to the groups:

  • In the RLS pane, click on “Add”.
  • Search for the Azure AD groups you created earlier.
  • Select the group and assign the appropriate roles.
  • Click “Save” to apply the changes.

8.png

 

By following these steps, you Can created two security groups in Azure AD and applied them to your Power BI dataset security for implementing Row-Level Security (RLS).

For more detailed information, you can refer to the following documentation:

Create a new group in Azure Active Directory

(https://docs.microsoft.com/en-us/azure/active-directory/fundamentals/active-directory-groups-create-...)

Row-level security (RLS) with Power BI

(https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls)

 

Best Regards,

Albert He

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors