Forum Discussion
Limit users ability to view reports - dashboard access only
Within our organisation I have created various dashboards and given relevant users access to certain dashboards, not everyone has access to all of them. I thought this was all working well however I have just discovered that by clicking on any visual in the dashbaord the user gets access to EVERY page and visual in my report(!).
No, I will first of admit that this has been caused by a lack of thorough due dilligence by me however I am quite suprised.
Is there anyway that I can limit this. Once I have provided people with dashboards I only want them to view report pages containing those visuals, or even more drastically, not allow them to view the report at all.
On a side note, how would I create multiple reports without having to rebuild my entire data set for each report? Currently I have one data set which is linked to a single PBX file. I make import all my data via this, create measures, make visuals etc and then publish to PowerBI in a report (and dataset) called "Company Data".
Is there a way I can create multiple reports without having to build a wholoe new data set each time which would be a mess to maintain.
Thanks.
maracles By design when you share a dashboard regardless of whether you had one pinned visual on it or pinned live page, user you've shared with gets access to same dashboard, reports and data as yourself including all the reports that you have within that pbix.
In order to use single dataset for multiple reports, once your dataset is published from powerbi desktop to powerbi service, in powerbi.com under Datasets click open on your dataset -> create visuals as required -> file -> save as. This will create a new report using single dataset.
14 Replies
maracles By design when you share a dashboard regardless of whether you had one pinned visual on it or pinned live page, user you've shared with gets access to same dashboard, reports and data as yourself including all the reports that you have within that pbix.
In order to use single dataset for multiple reports, once your dataset is published from powerbi desktop to powerbi service, in powerbi.com under Datasets click open on your dataset -> create visuals as required -> file -> save as. This will create a new report using single dataset.
ankitpatira Thanks for your response. I've had a look and that is what I will have to do, although it would nice to do this from within the PBX file itself.
Also, it feels like this is going to make maintenance and management of reports a little more complicated!
maracles are your shared dashboard visuals pinned to dashboard, or a whole report pinned live?
in scenario 1, navigate to the dashboard --> click open menu "...." --> tile detail --> set a custom link (could be any website) in this case when any user press the visual in the dashboard, it will redirect them to the custom link
in scenario 2, if you have pinned a live page (personally I love this option, as it gives the same awesome interactivity function of a report) --> go to tile detail --> untick the first box "title and subtitle" now your users won't be able to drill down to the report, and they still can use the functionality of a report inside a dashboard.
I created 46 pages in a report, each for a sales user, to maintain data protection
Hello,
I'm trying to do something similar, but ran into an issue with testing out "scenario 2". When the dashboard is shared with someone, they can't click through to the whole report; however, they can click "..." in the corner, then click "go to report", and in that way access all pages and the entire report.
Does anyone have a solution that gets around this, and completely prevents the end user from accessing the entire report?
Thanks!
I have the same problem. User can click "..." in the right corner, then click "go to report" and view all pages and reports.
I only want users to view the reports on Dashboard.
Is there any way to do?
Thanks!
majdkaid22 Thanks for those suggestions. Both could come in useful but the second one especially.
using scenario 2, disable the heading on the dashboard.
. Getting automatic access to the report seems ridiculous and thankfully I discovered it just in time. otherwise what is purpose of creating user based dashboards when each user could access the whole report.
however, seems users can still access the whole report, particulary using the application on a tablet.
