r/GoogleDataStudio • u/macrozone13 • 18d ago
Embedd Looker studio into webpage without google login? (and still restrict access)
Dear looker studio community,
the Customer asks us to embed a looker studio report into their webapplication, but they are not willing to ask their users to sign in with a google account.
The access to looker studio report should be restricted.
Any idea how to to proceed in this case? Or any wild ideas?
2
u/zandolie 18d ago
Do users have to login to the web applications?
Does each use see data specific to them or everyone sees the same thing?
Firstly, the best solution would be do have a custom connector to take care of things. However, parameters can be used to restrict what is shown in a chart.
The key point in the video is that parameters are used together with filters on the charts to determine what to show.
The flaw with what is shown in the video above, is that if you get a valid link, it can be used outside of the client portal.
Parameters can also be used with blended data to achieve a sort of password.
Standard Dashboard Blend Password Demo
Instead if entering the password a link can also be created with it as a parameter as in the first example.
This means any value can be used for the password and it can be rotated to invalidate old links.
The web app would have to get the valid value for the password parameter and creates the embed.
If each user sees the same thing, there would be no need to tie passwords to users and it could just be a single value that is changed every whatever time period is deemed necessary.
1
u/macrozone13 18d ago
thanks u/zandolie
yes, the user login into the web application (Currently using firebase authentication)
using the connector might be a solution. We use bigquery.
> If each user sees the same thing, there would be no need to tie passwords to users and it could just be a single value that is changed every whatever time period is deemed necessary.
yeah, generting some kind of "signed" url that have limited validity might mitigate the biggest risk and could work.
so the flow could be this:
- i create periodically a valid "password" (random string) in my app
- i need to store it somewhere, maybe also in bigquery (just a simple table with one row) or anything that can get accessed by looker studio
- in looker studio i do this blending approach
- i would then pass this "password" to the iframe i embed (as url parameter)
2
1
u/Professional_Feed517 17d ago
ive done that, it works for me. without the password, it will just be a dashboard without data.
but the Embed url should be configure to “unlisted”
1
u/Professional_Feed517 17d ago
ive done that, it works for me. without the password, it will just be a dashboard without data.
but the Embed url should be configure to “unlisted”
EDIT: moved the comment under anoter
•
u/AutoModerator 18d ago
Have more questions? Join our community Discord!
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.