How to Block an Account

How to Block an Account

Data sources (accounts) that you've disconnected may unexpectedly reappear in your Sources section. This guide will help you understand why this happens and provide two effective solutions to permanently block a data source.

Understanding the Issue

Why Disconnected Data Sources Reappear

A connected data source will only appear under Sources in the hub if at least one report is using the data source. When you disconnect a data source in Power My Analytics, it may still show up in your Sources section if:

  1. At least one report is still using the data source
  2. A report attempts to pull data, triggering the source to reconnect

This can happen with Looker Studio reports, spreadsheet reports, or Data Explorer reports.

Solution 1: Remove the Data Source from Reports

This method requires a manual review of all your PMA reports to identify and remove the disconnected data source.

Steps to Remove the Data Source:

  1. Check Looker Studio Reports
    • Review all your Looker Studio reports by going to the Reports tab in Looker Studio
    • Ensure none are using the disconnected data source
    • Remove the data source if found in any report
  2. Check Spreadsheet Reports
    • Examine all Google Sheets or Microsoft Excel reports using the PMA spreadsheets add-on
    • Ensure they're not using the disconnected data source
    • Remove the data source if present
  3. Check Data Explorer Reports
    • Go through all reports in Data Explorer
    • Confirm none are using the disconnected data source
    • Remove the data source if found

Note: Google doesn't provide a way for PMA to automatically locate all Looker Studio reports using a specific data source.

Solution 2: Block the Data Source in Sources

This approach doesn't require identifying specific reports using the source.

Steps to Block a Data Source:

  1. Navigate to the Sources section in your PMA hub
  2. Locate the data source you want to block and click the blue arrow next to the source



  3. Select Block Connection and click Confirm to block the account

Important: Do not remove the data source from Sources. Removal will also remove the block, allowing reconnection when a report attempts to access it.

You will see this symbol next to blocked accounts in your Hub: ðŸš«



If you change your mind in the future, you can unblock the account by clicking Unblock connection.



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

      • Related Articles

      • Manage and Remove Accounts

        This article will show you how to manage and remove your connections and teach you how it will affect your bill and reports. How to Remove an Account 1. Begin at your Hub. Click Sources on the left navigation panel. Click the blue arrow icon next to ...

      • What is an "Account?"

        For billing purposes, an account is a data source for which you create reports. You are not alone in asking. We get this question a lot! It is confusing because for each connector, it may be called something different. What an account is In Facebook ...

      • Why Does PMA Request Permission to Access My Account?

        When you first connect a data source with Power My Analytics, you'll be prompted to authorize permissions for PMA to access your account. Customers often want to know why access to their entire account is necessary just to read data from a source. We ...

      • Which Amazon Seller Central Markets Are Supported? Do I Need More than One Account?

        This article will help you understand how we calculate accounts in our Amazon Seller Central connector and how to filter sales by Marketplace in your reports. Billing and Accounts For billing purposes, each region counts as one account under the ...

      • Google Account Disconnects When Using Google Workspace

        This article will assist you with the following errors: In Looker Studio: Please click "REFRESH AUTHENTICATION" and reauthenticate with Power My Analytics/Authorization Error - Access Token Expired, please disconnect and reconnect In Google Sheets: ...