Forum Discussion

Zawadowski's avatar
Zawadowski
New Member
2 years ago

Get PowerBi Audience users via REST API?

Hi,   I've got a report showing all applications and users having access to these applications. Some of the applications have multiple audiences with different users assigned.   When querying PBI...
Need Help
Sabarivel's avatar
Sabarivel
Regular Visitor
1 year ago

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.

  • anwarbham's avatar
    anwarbham
    Icon for Advocate I rankAdvocate I
    1 year ago

    Hi

    providerKey is the App ID ,
    if you use the power bi api reportsasadmin
    you have the reports linked to each app
    in my case it was 
    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

     

    • Sabarivel's avatar
      Sabarivel
      Regular Visitor
      1 year ago

      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. 




      • anwarbham's avatar
        anwarbham
        Icon for Advocate I rankAdvocate I
        1 year ago

        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