cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jdusek92
Helper III
Helper III

Power BI APP - multiple reports with different permissions

Hello,

I have a question about Power BI APPs.

 

I have 3 reports that show HR data:

  • Report A - shared with 10 people via Link (Not via Workspace - they cannot have the Build permission/ see underlying data)
  • Report B - shared with 20 (report A + 10 users) people via Link (Not via Workspace - they cannot have the Build permission/ see underlying data)
  • Report C - shared with 10 (same as report A) people via Link (Not via Workspace - they cannot have the Build permission/ see underlying data). +Uses Row Level Security via UserPrincipalName

I want to create an App to that will join all 3 reports into one. But I still want the original permissions applied. So that users will see in the app exactly the same data as in individual reports.

 

I am not sure how to properly share the App with the users. I am afraid that sharing the app will overwrite the original report permissions + Row Level Security.

Users cannot have access to the data set, they can only see the aggregated data in the visualizations.

 

Can you please advise how to share the app to achieve this?

 

Warm regards,

Jakub

1 ACCEPTED SOLUTION

That would be nice, wouldn't it?  In reality you have two options

 

a) allow tenant wide auto installation of apps.  We would never ever do that in our org but your situation may be different.

b) your users need to "install/register"  the app before they can use report links. This is a one time thing, but it is a step that cannot be skipped.

View solution in original post

5 REPLIES 5
jdusek92
Helper III
Helper III

is the original Rowl Level Security applied, when I add that report to the App and Share the app? 

Row Level Security is a feature of the dataset, it has nothing to do with/ is not influenced by the report or the app. 

so when users already have access to those 3 reports via share link (they are not members of the workspace), I do not need to share the new app with them, when created?

That would be nice, wouldn't it?  In reality you have two options

 

a) allow tenant wide auto installation of apps.  We would never ever do that in our org but your situation may be different.

b) your users need to "install/register"  the app before they can use report links. This is a one time thing, but it is a step that cannot be skipped.

View solution in original post

lbendlin
Super User
Super User

At the moment it is still "one app per workspace". If you have sufficiently distinct audiences then you need to use separate apps for each of your audiences.  All of the reports in these apps can point to a common "golden" dataset if you want to keep the development effort in check.

 

Denying users build access is not user friendly.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!