When creating reports in Data Studio using Power My Analytics data sources, you may encounter the "Please click 'REFRESH AUTHENTICATION'" community connector error. This guide will walk you through understanding and resolving the error, ensuring seamless access to your data.

Error

• Data Sources Affected: Any
  
• Data Destination Affected: Data Studio
• Occurs: When attempting to create a report using a Power My Analytics data source in Data Studio

Causes

This error can occur due to several reasons:

1. Recent changes to your account password
2. The person who connected to the data source no longer has access 
3. Inadvertent loss of one of the API tokens (very rare)
4. The permissions for our App were recently changed
5. Glitch during the initial data source connection process

Solution

Follow these steps to resolve the error:

1. Access Power My Analytics Hub
   
   • Navigate to https://hub.powermyanalytics.com/
   • Select Sources from the left-side navigation panel
2. Disconnect the Affected Source
   
   • Locate the data source experiencing the error
   • Click the red "exit" icon to disconnect the source
     
     
     
     
   • Note: This action will not impact your existing reports
3. Reconnect the Data Source
   
   • Click + New Data Source
   • Follow the steps to reconnect your account
     
4. Retry Connection in Data Studio
   
   • Return to Data Studio
   • Attempt to create your report using the reconnected data source