Get user wise list of reports that they have access

[Het_117]

Hello community, 
I am looking for a way to "get all the reports list, that users have access to"

For example there are three users (A, B, C) and two reports (R1, R2), now need a table that shows data like below table.

User	Report
A	R1
A	R2
B	R1
C	R2

Is there any way, any REST API or any workaround to implement this ?

[Anonymous · Accepted solution]

Hi @Het_117 ,

As far as I know, you can try Power BI REST API:  Admin - Reports GetReportUsersAsAdmin.
It will return a list of users that have access to the specified report. 

You can get all users for R1 and R2 and then do some transformation to combine data.

Best Regards,
Rico Zhou

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

[Het_117]

Thanks @Anonymous, this solution worked 👍

[lbendlin]

I am not aware of any API to query audience membership, neither for users nor for reports mapped to audiences.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com