Data Studio, Multi-Level User Access Control with Google Sheets Data in Your Reports
Learn how to give users multi-level access to Google Sheets data in Google Data Studio reports. We'll split our data and show how we can give manager or other level access to Google Data Studio Reports.
Sign up to get updates, practice files and code snippets eepurl.com/hwyGg1
#datastudio #googlesheets #access
Пікірлер: 43
This is so affective for a multirole company like mine... 👍
This is great, Excellent video, Thanks!
Thank you for the clean and quick walk-through. Very easy to understand. Just out of curiosity, have you been able to still get the ACL to work when you have multiple data sources? I am in a situation where I can blend multiple sources, but I have too many metrics and dimensions for the limit. Any thoughts on that?
Awesome, this is what expected
great♥
Thank you for posting! This is easy to follow & replicate.
As always, amazing content
@ExcelGoogleSheets
3 жыл бұрын
Much appreciated!
Nice, let me try at my google studio 👍
It would have helped if you had the link to the previous video in description
Thank you so much for this video. I am so happy I've found your channel 👍👍
@ExcelGoogleSheets
3 жыл бұрын
Welcome!
Any idea how to do this for a multi-level org chart. Basically the higher you go in the company the more data they could see. I understand how to do an ACL for two levels worth of data, but once you start adding more levels it gets complicated.
Very good! Question! This works with other e-mails providers (not gmail)?!
Is it possible to create an access for manager to see all the data of their employees while employees can only the data they have access over?
Great Video thanks for this! I did just have a quick question about the dimensions limits when you blend data? I seem to only be able to have 10 dimensions but I have some data sets with between 15-20 columns. Any suggestion here? Thank you in advance. Luke
Thanks for the video.. Accomplished exactly what my mentors asked, however they think the repetition of the emails is not elegant enough of a solution.. They proposed I used an array, but I don't see how that would work in a spreadsheet.
@ExcelGoogleSheets
2 жыл бұрын
Nigher do I. But then people say one thing but it turns out them mean something completely different.
Hey I want to collect result details class wise of each section in same performa with different entries in one performa multiple times. Is there any way to do this? Please help
How to give report access based on their roles? Like L1 employee sees their own data (~12000 employees), L2 employee should see their reporting L1 employees (~4000), L3 should see L1 & L2 reporting into them and so on
I have a sheet with cells with hyperlinks but the hyperlinks are named so they don't show the full hyperlink, how can I get Studio to launch these still? The only way it's launching them is if I have the exact url in the cell.
Can you do this without emails and just passwords? For each page?
Hi - can you share a link to the previous video you mention right at the start? Thanks!
@ExcelGoogleSheets
2 жыл бұрын
kzread.info/dash/bejne/iIps18uAZau-gLQ.html
hi, thanks for your video, awesome job! I tried to use it for piechart but somehow it does not work, but works well for table, do you know why?
@ExcelGoogleSheets
2 жыл бұрын
That's weird, I don't know, it shouldn't matter.
@yantiratnasari4083
2 жыл бұрын
@@ExcelGoogleSheets found out the problem, it worked, thank you
can we do this too in Google sheets? 😭😭 I am searching for this feature. if not. Is there a way to make the auto refresh of looker studio to 1 minutes or 5 minutes?
How can i link multiple email-ids of the same person with his unique data Can you help me please?
some of my customers by email they receive an empty tables!!! Do you have idea how can I fix this?
@ExcelGoogleSheets
2 жыл бұрын
Maybe there is some sort of mismatch, like a space in email field. It could also happen if they have multiple google accounts and they could be logged in under the wrong account.
@diyaaeldin
2 жыл бұрын
@@ExcelGoogleSheets thank you for your prompt reply, I note sometimes when there is an uppercase letters in the email it isn't work!
@ExcelGoogleSheets
2 жыл бұрын
@@diyaaeldin Assuming emails are in column A, add a column in your spreadsheet =ARRAYFORMULA(LOWER(A2:A)) then use that column for email verification in datastudio.
hey Dear teacher can you Post Google Locker/Studio Tutorial Like You Do AbouT Google Sheet And Excel
Users cant refresh the datastudio any solution ?
@divi12345
3 жыл бұрын
Give them edit right and ask them to refresh data as shown at the end of this video
@anupshrestha6989
3 жыл бұрын
@@divi12345 if i grant edit permission to user the can edit settings or setup ... So any other way to handle this.
@divi12345
3 жыл бұрын
@@anupshrestha6989 i have tinkered a lot to find a solution, end result was this, so no other solution as far as my knowledge Custom app pages might help, i thing that’s a good topic for new video series
@anupshrestha6989
3 жыл бұрын
@Do Viet what about instant refresh if user wants to update and check the data... We cannot wait for 15 mins to see a data in datastudio.
@ExcelGoogleSheets
3 жыл бұрын
If you can't wait 15 minutes then I'm afraid you're either going to have to build your own system for reporting or create a bot that will click on refresh button on your editor account every minute or something.
It is free or paid??