Forum Discussion
Get PowerBi Audience users via REST API?
anwarbham , Thanks for sharing the unique information. Please let me know how to get the Report/Dashboard GUID and the visibilty for the Target Audiance group.
The report id in the output of ['appViewDetails'] is '2202319' where as the actual report GUID is different. How to map and get the actual report id. I am trying to collect ist of Target Audiance Group, associated user/AD Group, List of visible reports.
Appreciate your help.
Hi
with reports as
(
select
distinct
appId,
id,
name
from
reportsasadmin
)
select distinct
audience.AudienceName,
audience.providerId,
audience.AppId,
audience.AppDisplayName,
audience.Users,
audience.AdName,
audience.`Group`,
reports.id as ReportId,
reports.name as ReportName
from audience
left join reports on reports.appid = audience.AppId
order by AudienceName, Users asc
anwarbham thanks for the explaination. Here I am trying to get the list of reports the traget audiance group has access to. The reportIds[] array has list of visibile reports for each target audiance group. This array dosent have actual report GUID.Instead it has '2202319'.So how can I get the reports for each target audiance group?
Please advise.
can you extract the providerKey that is the app ID, Power bi has an api that lists the reports linked to an APP, Or check the "navigationJson" attribute it has ObjectId , this is the Report ID
With app ID we can get the associated reports through API call. Also in the navigationJson, we have Report IDs(Object ID) as you mentioned. The challenge here is only in the appViewDetails we have the visilbe report IDs ('2202319') for the Target Audiance. With this string ' 2202319' I need to get the actual report GUID.
Please suggest.