Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Connect to Azure AD for usernames and groups

Hello everyone,

 

I'm trying to set up Dynamic RLS for my organization. 

I can use Active Directory connection to get every username and group that i need for that.

 

My issue comes with guest users, that are only in Azure AD and not in the AD of my Organization. 

 

So, with Power BI, can i get thoses informations (usernames and groups) by using the connection tool ?

Or is there another easy way to do this ? 

 

Thanks in advance. 

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    I suggest you to add your guest user to a security group and set a role for the gourp to work around.

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      thanks for the answer,

       

      The security group is not actually in our AD.

      Still, even if it was, i couldn't acess users and get mail adress to set up dynamic RLS and a role for them.

       

      The only thing we though of is to create a powershell script to request azure AD, then import the flat file produce in PBI.

       

      Any idea ?

       

      Thanks again in advance,