As they say, sharing is caring… and also an important feature in Google Data Studio! You have probably been in a situation, where an employee leaves your agency/company and all the access to reports and data sources leaves with them. The problem is that often, managing data ownership and access level is the aftermath, as opposed to a carefully designed transition process.
In this post, I want to show you how to completely transfer ownership of reports and data sources, so that the new owner is able to edit the report front-end, configure new fields and change the data schema. Plus, a few caveats of access management.
The first thing we would normally do to allow another user to access our Data Studio report is to simply navigate to the “Share” button and assign them a “Can edit” role.
Of course, this would only provide the new user with access to the report charts and fields that are already available. As you can see, the “Data Source” field below does not have an edit option. The separation between the data source and the report itself is also common practice in other data visualization tools. Its main purpose is to add an extra layer of security.
Now, let’s go a step further and share the data source to enable the new user to create dimensions/metrics. You can do that by going to “Data Sources” in the main interface and assign “Can edit” access.
…and voilà, your new user is now able to edit the data source. This includes adding new fields and also changing aggregation and data types to existing fields. Not quite full access yet.
The last and missing piece here is being able to edit the data source connection and update it. This can be achieved by going to the “Data Sources” menu and changing the “Can edit” access to “Make owner”. Bear in mind, once you transfer ownership to someone else, that person can remove your access or modify the data source connection and you will not be able to revoke the connection. Therefore, be careful with the feature, as it is extremely powerful.
When you finally have owner access you would see a few more buttons light up in your Data Studio report. It is a good practice to review access levels of clients and employees that are changing departments or leaving your company. In this way, you can avoid broken reports and missing data sources in the long-run.
I hope this was helpful! If you have any questions, feel free to DM me on LinkedIn or subscribe to my newsletter for more updates 🙂
After covering ChatGPT and testing Zapier AI Actions, I thought I will explore Microsoft Copilot…
I've used Zapier for years to automate small tasks and create the lead generation system…
When I started creating custom GPTs for various tasks, one of the areas that I…
Over the past few months, I've had the opportunity to dive into Canva Magic Studio,…
In my nano tips series on ChatGPT so far, I've covered Data Storytelling and Visualization,…
It has been a while since my last post, but I finally managed to wrap-up…
View Comments
Hi There,
I want to transfer ownership. I have granted edit access to my colleague. Now when I go to manage access, I do not see 'Make owner' option. I am using Basic version of G-Suite for non for profit.
I can see option 'Can edit' , 'Can view' and 'Remove' options.
Your guidance will help me resolve the issue.
- Sanjay
Hey Sanjay, thanks for the great question! There are a few levels of access management in Data Studio. Based on your comment, it seems like you have made your colleague a "Editor" of the report, so he/she can edit the charts and also modify the schema of the existing connection. To fully transfer ownership, you would have to navigate to the main Data Studio interface (the one before selecting or creating a new report) and go to the Data Sources menu. From there select "Make owner" for the data source linked to your report. Hope this help - Lacho :)
Is there a way to retrieve dataset from someone who already left the company and had their G Suite terminated?
Hey Watasit,
If you are a Google Workspace (formerly known as G Suite) member, then Google has a great support document on the topic that can help you out.
Let me know if this solves your problem :)
Lacho
Hi, how can I transfer ownership to a different domain?
Hi,
How can someone transfer ownership of data studio when that person already left the organization? Currently the dashboards/reports are currently inaccessible to our end as the original creator is no longer working with us.
Hey Renz, from my experience, prior to the employee leaving, the Data Source and Report access need to be transferred. If the employee has left and the account is deactivated completely, then nothing much can be done. However, if you re-activate the account that owns the reports/data sources or log into it, then you can still make the transfer.
Hi team,
We have one datastudio report whose owner has already left the organization. We want to change the ownership of that report as it makes some of the actions not possible to be made. Also there are some issues with the dashboard which could be amended after fixing the ownership.
Can you please help us with the steps to change the ownership of this report.
Thank you.