The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hello all,
I developed an app in Power BI, which contains 2 reports: Report A and Report B.
Then I created 2 audience groups: Audience A (only sees Report A page) and Audience B (onlye sees Report B page).
Now imagine I have 3 type of users: UserA (should only see Report A), UserB (should only see Report B) and UserAB (should see both Report A and Report B).
To avoid creating a 3rd audience group, since they are limited to 10 and I now for a fact that I have a lot of different types of users and will have a bunch of reports in the app), I tried to add UserAB to both audience groups (Audience A and Audience B).
After publishing the app, I check that UserAB sees the content of Report A (which is as expected) and he has the option to click in Report B but once clicked he receives a message saying he has no access to Report B.
Is this some kinf of bug or its normal behavior? I use this approach in RLS, adding the same user in multiple roles and if works fine, but apparantely this is not working in the app audience groups.
Do you guys have any suggestion?
Thank you,
Marta
If they are in Audience A and Audience B, they should see three menu options.
ALL, Audience A, and Audience B.
The ALL gets added so they can see all of their stuff across all audiences. I would check permissions and republish the app.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHi edhans, thank you for the answer. I know for a fact that that works, but what I am trying to say is that, imagine tomorrow all add a new report to the app (Report C) that should only be acessed by UserC, meaning that UserA, UserB and UserAB cannot see it.
Summing up:
- Report A should be accessed by UserA and UserAB
- Report B should be accessed by UserB and UserAB
- Report C shoul be accessed by UserC
In this case I cannot put UserAB in the "All" audience group because it will then see ReportC which is not the goal. Of couse I can add another audience group, but I am thinking about the future where I can have more than 10 audience group in the app.
I tried to put UserAB in both AudienceA and AudienceB but it seems to "fall" in the first group thus not seeing anything related to AudienceB.
Thank you in advanced,
Marta
You don't put any user in "All." All is there for that user. So User AB can see reports in Audience A and B. But the service adds a new menu for them called "All" that will show them all the reports they have access to without forcing them to bounce between audience A and B. But it will not show them C. "All" is not "all reports in the app."
I am not sure why when you add a user - user AB to audience B, they cannot see those in B. That makes no sense and is not what I am experiencing. You might remove them from B, republish, then add them back. If that fails. it might be a support call to MS.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThe think is that I am adding the same user (UserB) to 2 different audicente groups: AudienceA (only sees ReportA) and AudienceB (only sees ReportB).
I'll try to republish the app and recreate the roles.
I'm sure you have already solved this, but just in case, if Report B uses RLS, you'd still need to add users to the necessary Roles, in addition to the AudienceB.