Connecting to a Data Source - Power My Analytics

Connect to a Data Source

Power My Analytics has updated the Sources page to make it easier to view and manage your connected data sources. This article will guide you through the process of connecting a data source to Power My Analytics and managing your data source connections.

Understanding Data Sources

Before setting up your data sources in Power My Analytics, it's important to understand the basic terminology we use. By reading How Data Sources Work with Power My Analytics before getting started, you'll have a better grasp of these terms when navigating the Sources section and making decisions about your data connections.

What Power My Analytics Does for You Automatically

  1. Historic data collection: Most of our connectors start collecting up to 13 months of historical data as soon as you connect your data source. This process typically takes a few minutes, but for some data sources, it might take a couple of hours to complete the initial backfill. Some connectors allow you to perform backfills of data for 2 years or more.
  2. Daily data refreshes: We refresh your data every day at midnight with all our connectors. During these refreshes, we also update the past 7 days of data to account for any changes that may have occurred, at the time zone set at the data source level or individual account level. (Time zone selection is not available for all connectors.)

Add a New Data Source

To connect a new data source to your Power My Analytics hub:

  1. Visit hub.powermyanalytics.com to get started.
  2. Click on Sources in the left navigation panel, then click the orange "+ Add new source" button located above the main sources table.



  3. Select a connector from the data connector gallery.



  4. Sign in with your credentials for your account on the chosen platform.
  5. Grant Power My Analytics the required permissions to access your data.
Once connected, your new data source will appear in the main sources table and begin syncing data according to your configured schedule.


By following these steps and understanding our data collection process, you'll be well-equipped to create informative and accurate reports in Power My Analytics. If you need any assistance, don't hesitate to reach out to our friendly support team.

Google Sheets Error: "Please re-connect your account"


If you receive the error message "Please re-connect your account" while using a Google Sheets report with PMA's spreadsheets addon, follow these steps to ensure your data source is connected:
  1. Go to your Power My Analytics hub and click on Sources in the left sidebar.
  2. Select the Filter dropdown by Status and choose Disconnected to find the disconnected data source.



  3. Under the Action menu, click Reconnect to reconnect the source.



  4. If your data source is not listed under disconnected sources, click the + Add new source button to connect your account as a data source again.
  5. Refresh your Google Sheets report to verify that your report data loads correctly with no error. 
If you continue to receive this error when using Google Sheets, please follow the troubleshooting instructions at Google Account Disconnects When Using Google Workspace.


    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • How to Reconnect a Disconnected Data Source

        Sometimes a connected account can become disconnected from your Power My Analytics hub, causing errors in reports. This article will show you how to reconnect a disconnected data source in your hub and get your data moving again. What Happens When a ...

      • Disconnect and Reconnect a Source from Your Hub

        Are you experiencing errors in your reports? Many issues can be resolved by simply disconnecting and reconnecting a data source. This guide will walk you through the process. Issue Errors in reports that can be resolved by disconnecting and ...

      • How to Connect to Taboola

        This guide will walk you through the process of connecting your Taboola account to Power My Analytics, enabling you to automate your data collection and create insightful reports. Prerequisites Before you begin, make sure you have: Your Taboola ...

      • How to Connect to BigCommerce

        This guide will walk you through the process of getting the credentials you need to connect to BigCommerce with Power My Analytics. You will need to create an API Account and get an Access Token. Before Getting Started You'll Need A BigCommerce ...

      • Manage and Configure Data Sources

        Power My Analytics has updated the Sources page to make it easier to manage, configure, and monitor your connected data sources. This article will explain the features of the Sources section in your PMA hub and how to use it to manage your data ...