Google Sheets Error: "Exception: You do not have permission to access the requested document."

When working with Power My Analytics in Google Sheets, you may encounter an error message stating that you don't have permission to access a document. This guide will help you understand the cause of this error and provide steps to resolve it quickly.

Error

"Exception: You do not have permission to access the requested document."

• Data Destination Affected: Google Sheets
  
• Occurs: When attempting to load a Google Sheets report using the PMA add-on

Cause

This error occurs when you are logged into multiple Google accounts while using the Power My Analytics spreadsheets add-on.

Solution

To resolve this issue, follow these steps:

1. Manage Your Google Accounts:
   
   • Log out of all Google accounts except the one that has access to the spreadsheet you're trying to use.
2. Re-authenticate the PMA Add-on:
   
   • Open your Google Sheets report and locate the Power My Analytics add-on in the menu.
   • Log out of the PMA add-on.
     
     
     
     
   • Log back into the PMA add-on.

Best Practices

To avoid this error in the future, consider the following best practices:

• When working with PMA and Google Sheets, try to use a single Google account session.
• If you need to switch between accounts, always verify that you're logged into the correct one before accessing PMA reports.

• Related Articles

• Troubleshooting Google Sheets

  Most errors that occur with Google Sheets reports can be fixed easily without the need to wait for a response from our support team. This article will help you find everything you need to troubleshoot your Google Sheets reports. Google Sheets If you ...

• Error: Authorization Is Required to Perform That Action

  This article provides troubleshooting steps for the "Authorization is required to perform that action" error. This error can occur when using Power My Analytics with Google services, including the Google Sheets add-on, Data Studio connectors, or ...

• Google Sheets Scheduled Refresh Not Running

  You set up a scheduled refresh for a Power My Analytics report in Google Sheets, but the data does not update on its own. This guide helps you confirm the schedule is saved, re-authorize the add-on (the most common fix), read the add-on logs, and ...

• Google Sheets Error: "Exception: Service Timed Out: Spreadsheets" or "Service Spreadsheets timed out when accessing document"

  When using the Power My Analytics spreadsheets add-on in Google Sheets, you may encounter a timeout error that prevents your reports from refreshing. This guide will help you understand the cause of this error and provide a straightforward solution ...

• Google Sheets Error: "Exception: This add-on has created too many time-based triggers in this document for this Google user account"

  Your Schedule Refresh won't save, and Google Sheets shows an error about too many time-based triggers. This is a Google limit on the spreadsheet, not a Power My Analytics limit, and you can usually clear it yourself in a couple of minutes. Here is ...