Looker Studio: show/hide pages of a report depending on user

[carvanrod]

Hi!
I've created a report with like 5-6 pages or so. And I have embeded the report in a web platform.
Thera are 3 types of different users who can access to the report.
However I do not want 2 of them to be able to see 3 of the pages. 
Which will be the process to achieve this? Is it even possible?
I know that every page has an ID. But I want to do this in different platforms so I need the solution to be "modular" so I can use it everywhere. Are there any reachable variables that encapsulate the page id or something like that?
Is there any other way to do it?

Thank you very much in advance!

[dylantrose · Accepted solution]

Hi Carvanrod,

While there isn't a great simple way to do this, I can give a couple not great ways to get around the lack of feature.

1. Via your web platform

If your web platform checks for who is logged in, and is fairly modular JS wise, you can give them access to different IFrame URLs of the same report and turn off page accessibility so that they can only load and see the pages you are interested in showing them.

2. Via data filtering

You can change your data to add a column that contains the user's email and then use this tutorial to only assign data to each user based on their email. While this won't hide the extra pages you don't want them to see, it will hide the data on those pages so they will be blank.

3. Duplication

Depending on how many types of users you have, you may find that making multiple reports can be the solution. You can duplicate the report and remove pages you don't want them to see per report. Based on your request, that would mean you duplicate it once and make it so it only has 3 pages. Then you may have it so each user has access to a different report.

Hope this helps!

Dylan

[dylantrose · Accepted solution]

Hi Carvanrod,

While there isn't a great simple way to do this, I can give a couple not great ways to get around the lack of feature.

1. Via your web platform

If your web platform checks for who is logged in, and is fairly modular JS wise, you can give them access to different IFrame URLs of the same report and turn off page accessibility so that they can only load and see the pages you are interested in showing them.

2. Via data filtering

You can change your data to add a column that contains the user's email and then use this tutorial to only assign data to each user based on their email. While this won't hide the extra pages you don't want them to see, it will hide the data on those pages so they will be blank.

3. Duplication

Depending on how many types of users you have, you may find that making multiple reports can be the solution. You can duplicate the report and remove pages you don't want them to see per report. Based on your request, that would mean you duplicate it once and make it so it only has 3 pages. Then you may have it so each user has access to a different report.

Hope this helps!

Dylan

[carvanrod]

Hi Dylan,

Thank you so much for your help, I know is tricky but my team and I are gonna try a combination of these solutions, once again thank you so much!

[pype]

Hi there! I'm a product manager working on Looker Studio, and I am curious what if any workaround you went with for this use case. If you're open to a chat about your needs (and might like to contribute to the design of a product solution for this use case), let me know and we can set up some time to chat!

[ArkadyZagdan · Accepted solution]

Hello Carvanrod

A trick with email as parameter would do the work if you use a table with picture fully covering page.
You would have two options :

- User with an access will have 100% transparency picture and the data will be fully visible

- User without access will be feeded with no transparency with hex code color exactly same the Dashhboard  background.

Both users will be able to reach certain page but only one user will see data below the graphic image

I am not sure if this is clear if no then please refer to the screen I am using same trick to show/hide additionall info about the data here:

You can upload a full resolution grey backround and fully transparent one into google cloud bucket and feed them innto table as images. They will be displayed based on email of the user logging in to thhe tool.
Just like on the reply of @dylantrose 

I hope I did not confused you:)

heres theh URL to the report I am sharing :

https://lookerstudio.google.com/reporting/2c01b9cb-46e8-4f26-91d5-0f7299b92a3a/page/gZInD

Regards
Arkady Zagdan
(PII Removed by Staff)

[carvanrod]

This is a really interesting and clever solution. It's definitely something I'm going to try. Thank you so much!