Forum Discussion
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 referred the below links, but here anonymous authentication is used. Is there a way to use other authentication method ?
https://learn.microsoft.com/en-us/graph/api/group-list-members?view=graph-rest-1.0&tabs=http
https://www.sqlservercentral.com/articles/how-to-create-a-power-bi-report-using-rest-api-data
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.
1 Reply
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.