Data Studio
5.3K members online now
5.3K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

how to filter datasource based on user logged in?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Depending on the user role I need to filter the data on data studio dashboards.

I could't find any function that could be used on expression filter for the report datasource that would enable this.

Are there any plans to support this feature?

I saw in another post someone suggesting to use big query session_user(), but this is not the case, as big query results are cached, and this benefits my users.

how to filter datasource based on user logged in?

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @José Luís P

 

What is your data source? Do you have an event that fires when your users log in? Will you want to remove their data from the dashboard when they log out, or does this not matter?

 

Ben

how to filter datasource based on user logged in?

Participant ✭ ✭ ☆
# 3
Participant ✭ ✭ ☆

How many users to you have? If you just have a few, you could make a copy of the dashboard and put a filter on each one for that person. That way they each have their own URL. If you have more than a few, that's likely not scalable, though...

how to filter datasource based on user logged in?

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Datasource: Information from bigquery.

Do not know if data studio triggers events... does it?

I would like the data to be filtered when viewing the dashboard, as an automatic filter depending on the user logged in data studio.

thanks,

how to filter datasource based on user logged in?

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Yes a copy of the dashboard is what I am using now.

But every time I make an edition on the dashboard components I need to copy the dashboard to what ever group of users with similar filters...

It is not scalable.

thanks,

how to filter datasource based on user logged in?

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Hi there,
Seems to be an old post, but did you figure out the solution? I have to filter big query tables based on users.

Re: how to filter datasource based on user logged in?

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭
Still waiting too...--

*José Luís Prado*
Diretor
joseluis@itaueira.com
+55 (85) 4008-9100
celular | mobile +55 (85) 99925-1169
www.itaueira.com

facebook/melaoRei

f/ItaueiraTurmadaMonica

f/ItaueiraMelon


Esta mensagem é endereçada exclusivamente ao seu destinatário e poderá
conter informações confidenciais.
O uso não autorizado de tais informações é proibido e estará sujeito às
penalidades cabíveis.
*This message is intended exclusively for its addressee and may contain
information that is confidential. *
*Unauthorized use of such information is prohibited and subject to
applicable penalties.*

how to filter datasource based on user logged in?

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

Thanks for reply Jose Luis P. Have you requested it as a feature so that I can also vote? otherwise I will request .

Re: how to filter datasource based on user logged in

Visitor ✭ ✭ ✭
# 9
Visitor ✭ ✭ ✭
https://issuetracker.google.com/70709081
thanks,
--

*José Luís Prado*
Diretor
joseluis@itaueira.com
+55 (85) 4008-9100
celular | mobile +55 (85) 99925-1169
www.itaueira.com

facebook/melaoRei

f/ItaueiraTurmadaMonica

f/ItaueiraMelon


Esta mensagem é endereçada exclusivamente ao seu destinatário e poderá
conter informações confidenciais.
O uso não autorizado de tais informações é proibido e estará sujeito às
penalidades cabíveis.
*This message is intended exclusively for its addressee and may contain
information that is confidential. *
*Unauthorized use of such information is prohibited and subject to
applicable penalties.*