Add and Remove Accounts from Data Sources

Add and Remove Accounts from Data Sources

Info
Within a connected data source, accounts are subsets of data within data sources that can be selected individually to sync with PMA's data warehouse and use in reports. Accounts correspond to divisions within the data connector's platform, such as multiple pages under a Facebook Insights data source or multiple business locations in Google Business Profile.

Using the Manage Accounts Panel

In the Sources section of your hub, the Manage Accounts panel provides detailed control over individual accounts within your connected data sources. This panel allows you to configure settings, enable or disable specific accounts, and manage data synchronization at the account level.

Notes
Only enabled accounts will be included in your reports and data collection. Disabled accounts are automatically excluded from all reporting.
To access the Manage Accounts panel, select Action > Manage accounts next to the data source.


Add a New Account in a Connected Data Source

If you have a connected data source that contains multiple accounts (such as Facebook Ads with multiple ad accounts or Google Business Profile with multiple locations), you can enable additional accounts that are not currently active in your data source connection.

  1. Navigate to your Sources page in your Power My Analytics hub.
  2. Locate the data source containing the account you want to enable.
  3. Click the three-dot menu in the Action column and select Manage accounts.
  4. In the Manage Accounts panel, click the Enable Accounts button on the right.



  5. Under "Select accounts you want enabled or disabled," check the box next to the account name you want to include in your data source connection, or click Select all to choose all of the available accounts.



  6. Click the black Save button to confirm your selection.
Once enabled, the account will begin backfilling data and will appear in the Manage Accounts main table with an "All good" or "Syncing" status. The newly enabled account data will then be available in your reports and exports.
Alert
Hub account limit: If your Hub Owner has set an account limit for the hub, you may see a "Hub limit reached" message when attempting to enable additional accounts. This means the maximum number of connected accounts per data source type has been reached. Contact your Hub Owner to request an increase or removal of the limit in Settings > Account Limits. For more information, see Manage Account Limits in Your Hub.
NotesBilling impact of enabling accounts: Each PMA plan includes a set number of accounts, and enabling accounts beyond your plan's included quota can result in additional charges on your bill. On the Business plan, additional accounts beyond the 5 included are billed at $14.95/month each. On the Pro plan, additional accounts beyond the 10 included per source are billed at volume pricing rates, and overage charges are based on your single highest-count connector (whichever data source has the most accounts determines the overages for your hub). For full pricing details, see Billing Basics and Best Practices. Hub Owners on standard plans can proactively prevent unexpected overages by setting an account limit in Settings > Account Limits.

Understanding Account Availability

Enabled vs. Disabled Accounts

You can enable or disable accounts at any time using the Manage Accounts panel. Disabled accounts will stop syncing new data but can be re-enabled whenever you need them.

What "All Accounts" Means in Looker Studio

When configuring a PMA data source in Looker Studio, the Account multi-checkbox dropdown only displays accounts that have been enabled as synced accounts for that data source in your Hub.


If you select "All Accounts" in this dropdown, your report will include:

  • All accounts currently enabled to sync in your Hub within the connected data source
  • Only accounts that PMA currently has access to on the source platform

Important: If PMA later loses access to an account that was included in your report (whether individually selected or included via "All Accounts"), that account and its data will be automatically removed from the report.

Accounts with Lost Access

If you lose access to an account on the source platform - for example, if you are removed from a Google Ads account, lose admin permissions on a Facebook page, or are no longer associated with a business profile - that account will behave differently than a manually disabled account:

  • The account may still appear in your Hub's Manage Accounts panel but will show an error status indicating the access issue.
  • The account will not appear as an available option when configuring reports in destinations like Looker Studio, Google Sheets, or other integrations.
  • The account will not be included in "All Accounts" selections in Looker Studio, even if it was previously included.
  • Historical data for the account remains stored in your Hub, but you cannot create new reports using that account until access is restored.
  • Existing reports that included this account will have the account and its data removed automatically.

To restore reporting access:

  1. Verify your permissions on the source platform and request access from the account owner if needed.
  2. Once access is restored, reconnect or reauthenticate the data source in your Hub.
  3. The account should then reappear in your destination configuration options and be included in "All Accounts" selections.

Still Have Questions?

No worries - we're happy to help!

    • Related Articles

    • 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 ...

    • How Data Sources Work with Power My Analytics

      We understand that getting started with a new tool can be a bit overwhelming. This article will explain how Power My Analytics connectors, data sources, and other core features work together to provide fast and reliable data for your reports. ...

    • Why Can’t I See All of My Accounts in My Hub?

      Have you connected to a source but cannot see all of the associated accounts in your Hub or when configuring reports? This article will help you understand why accounts may be missing and how to resolve common issues. General Reasons for Missing ...

    • Request Access from a Source Owner Using Auth Links

      Need to connect a data source but don't have direct access to the account? Auth Links allow you to send a secure authorization request to the source owner — such as a client or colleague — so they can authenticate on your behalf, without ever sharing ...

    • Report Data in Power BI

      Power My Analytics offers a native Power BI connector that allows you to load your Data Builder datasets directly into Power BI Desktop for custom reports and dashboards. This guide walks you through connecting your PMA hub to Power BI, installing ...