How do I update my reports after changing hubs?

Migrate Connections to a New Hub


If you've created a hub and reports with the connections, then change your mind later or would like to consolidate payment on another hub, you will need to migrate your connections to the new hub.  If you do not migrate the connections but the bill is no longer being paid on the original hub, your reports will stop working.




Before You Proceed:

Migrating a Hub is a lengthy process. Most of our customers can save a lot of time by simply changing their Hub's owner or adding a billing contact.
  1. Do you need help changing your Hub's owner or adding a billing contact? Please read this article: Manage Team Roles and Permissions
  2. Do you need to add or remove a team member? Please see this article: Add or Remove Team Members

If you are certain that you want to migrate all of your reports' connections to a new Hub, please follow these steps:

Create the new Hub

If you haven't already, create the new Hub or obtain an invitation to the new Hub.
Your membership or ownership of the new hub is required to create new connections with your data sources.

Connect to data sources in the new Hub



Need more help with this step? Follow the instructions in this article to connect to data sources in your new Hub: Connect to a Source

Migrate Looker Studio reports to the new Hub

Go to Edit mode in your Looker Studio report.



Click Resource at the top of the page, then Manage Added Data Sources.



Click Edit next to the source that needs to be reconnected.



Click Edit Connection on the top left side.



Make sure you select the new Hub and the correct account. Click Reconnect.



You may receive a notice that No field changes were found. Click Go To Fields to continue.



Or you may receive a message that new fields were added or removed. Review the changes and click Apply to continue.



Click Done to apply the updates and finish reconnecting to the data source.


If your Hub still does not appear, follow this linkSearch for the data source you are trying to connect to and click on the 3 dots to the right of the connector. Then click Revoke Access .



Then connect again.

Migrate Google Sheets reports to the new Hub

Open the report you want to edit. Click Extensions, select Power My Analytics and Show Sidebar.



Next to the report you want to migrate, select the three dots then click Edit.



Select Data Account and then use the drop-down menus to select the new Hub and the appropriate Account.



Click Update Report.




Migrate Excel reports to the new Hub

Open the report you want to edit. Click Data Connector to open the sidebar tool.



Next to the report you want to migrate, select the three dots then click Edit.



Under Data Account select the new Hub and the correct Account. Then click Update Report.



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

      • Disconnect and Reconnect a Source from Your Hub

        Many errors can be fixed by simply disconnecting and reconnecting a data source. Your reports will not be impacted. This article will show you how. Disconnecting your data sources will not pause your subscription from being billed. To pause billing ...
      • Change Hub Owner's Email Address

        This article will help you when you need to change the email address associated with your Hub because you no longer use the old email address or have lost access. If you can still access the old email account: 1. Add the new email address as a team ...
      • Manage Team Roles and Permissions

        As a Hub owner, you may want to add team members as editors or billing managers to delegate roles and provide access. This article will show you where to find the tools you need to manage your team. Team members are users who authenticate and connect ...
      • How to Use Sample Data

        Sample Data allows you to showcase templates and reports to potential clients without sharing sensitive information. Read this article to learn how to use Sample Data in Looker Studio. Can I Use Sample Data? Currently, Sample Data is only available ...
      • How to Reconnect a Data Source

        Reconnecting the data source should always be the first thing you try if you are receiving unexplained data errors on your Looker Studio report. Follow the instructions in this article to reconnect your data source and get back up and running in ...