Forum Discussion

Rohitb's avatar
Rohitb
Helper I
2 years ago
Solved

Extract user from Azure Active Directory

Hello, I have a requirement to create PowerBI Report that needs to extract data of the members within Security group within Azure Active directory, so can someone help me with this ? I have r...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Rohitb ,

     

    You can export AAD users to a CSV file first and then Power BI imports the data from the CSV. You can use any other intermediate data source, such as Excel, SQL Server, etc., if desired. Simply use its PowerShell cmdlet or parameters to perform this operation. More details are available at the link: Import Azure Active Directory Users into Power BI; An Step toward Dynamic Row-Level Security - RADACAD .

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Rohitb ,

 

You can export AAD users to a CSV file first and then Power BI imports the data from the CSV. You can use any other intermediate data source, such as Excel, SQL Server, etc., if desired. Simply use its PowerShell cmdlet or parameters to perform this operation. More details are available at the link: Import Azure Active Directory Users into Power BI; An Step toward Dynamic Row-Level Security - RADACAD .

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

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