Update a shared query (Power Query)

Important   This article applies to Power Query, a data analysis feature available for Excel that lets you discover, combine and refine data. You may need to enable Power Query in Excel. You can also download and install the most recent version of Power Query for Excel, which automatically enables it. Power Query technology is also built into the Power BI Desktop, which is a stand-alone report authoring and data transformation tool for Power BI.

Note   This article applies to the original release of Power BI for Office 365. For information about the most recent release of Power BI, please visit Power BI.

In Power Query, you can replace or overwrite a shared query. You can only replace a shared query that is shared by you.

Update a shared query:

  1. From Power Query, sign in to Power BI. In the POWER QUERY ribbon tab, select Sign In. In the Sign In dialog box, select Sign In, and then enter your organizational account information that was used when you signed up for Power BI.

    Sign in to Power BI

    Important    Signing in to Power BI using your organizational account enables you to view the queries that you shared within the organization. You cannot view/access your shared queries in Power Query if you are not signed in to Power BI.

  2. Import the newer version of data to the Excel sheet either by directly connecting to the appropriate data sources using Power Query or by importing the data from a newer version of the shared query. For more information, see Connect to Internal and External Data Sources and Find and Use Shared Queries.

  3. In the QUERY ribbon tab, click Send To Data Catalog.

  4. In the Send to Data Catalog form, click Update.

The selected shared query is overwritten with the newer version of the data source and updated metadata values specified in the Replace Existing Query dialog box.

Related Topics

View and Update Your Shared Queries

Share Queries

View Your Shared Queries using the Manage Data Portal

Data Management Experience in Power BI for Office 365 Help

Applies To: Excel 2013

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language