Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Auto Update Audience in Power BI Apps

Hi Team~

 

Is there a way to automate to add or update specific user/groups in an audience tab for Power BI App?

We are currently searching for a solution wherein we need to add / update hundreds of security groups in an audience tab without having to add them all manually? 

 

Example:

We have 2 kinds of audiences in the Power BI App: Finance Audience and Sales Audience. We also have 500 AD Groups that needs to be added in those audiences, since each department has their own AD Group. 

 

Big thanks!

  • ibarrau's avatar
    ibarrau
    2 years ago

    Kind of. Yes. I think you could make a script with PowerShell to work with security groups. But I'm not sure if writting that script delimiting specifically which security groups to groups in another groups will take more or less time than clicking 500 groups in the UI.

    I hope that make sense.

4 Replies

  • Hi. The way of auto upgrade users to Power Bi App is using security groups. That way when a new person is added to the group, they can automatically have access to the report. In your case you might be able to create a security group of the AD Groups. That way when you add one to another, they will see the app.

    Audiences is kind of a recent feature, so it doesn't have API requests yet.

    I hope that helps,

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks for the response ibarrau. Does this mean that if we have 500 security groups, we need to add all 500 of them manually? 

      • ibarrau's avatar
        ibarrau
        Super User

        Kind of. Yes. I think you could make a script with PowerShell to work with security groups. But I'm not sure if writting that script delimiting specifically which security groups to groups in another groups will take more or less time than clicking 500 groups in the UI.

        I hope that make sense.