When opening TMR in Looker Studio users may receive this error message.
If you have received the error message “⛔️ Permission Denied: Unauthorised! User abc@gmail.com does not have access to this Report/Data source in team TeamName” while using Two Minute Reports (TMR), it means that you are trying to access a Report/Data source that belongs to a different team.
Why does this happen?
A Report/Data source in TMR is always associated to a Team. Whenever someone opens Two Minute Reports inside a Report/Data source, by default his/her Team gains ownership of that Report/Data source.
Let’s learn what a Team is. A team maintains the user permissions to Data Sources, Queries and Report. A user becomes part of a new Team and becomes its owner when her/she creates a new TMR account. All Data sources, queries that they create gets associated to this TEAM. Apart from that, when they access a Report/Data source and open TMR, that Report/Data source also becomes part of that Team.
When you receive the above error message, it means that you are trying to access a Report/Data source that is part of a different Team.
How to Resolve this?
There are three possible actions you can take to resolve the issue.
- Verify your login email ID: To check if you are signed in with the correct email address, go to your account settings and verify the email address associated with your account. If it’s incorrect, sign out from Gmail and sign back in with the correct email address.
- Ask the owner of the team to add you as a member: If you are not a member of the team, you will not have access to the Report/Data source. Refer this article for detailed instructions on adding team members to a Google Sheets team. Contact the team owner and explain the situation, requesting their assistance in adding you as a team member from the Accounts portal (apps.gox.ai). Once the team owner has added you to the team, you should gain the necessary access privileges to the Report/Data source.
Example scenario: Let’s say that you are a new member of a team and trying to access a Report/Data source that was created by another member of the team. However, you receive the “⛔️ Permission Denied” error message. In this case, you can reach out to the owner of the team and ask them to add you as a member. Once you are added as a member, you should have access to the spreadsheet.
Example scenario: Let’s say that you have two accounts with Two Minute Reports and you want to consolidate all your Report/Data source, data sources, queries, and schedules into single account. In this case, you can initiate the migration process to move all the relevant items from your old account to your new account.
Hope this article was of use to you. Thanks and cheers!