Delete a shared query

[ Power Query version 2.10 ]

You can delete your shared queries in Power Query if the data represented by the shared query is no longer relevant to the business. You can only delete queries shared by you.

To delete a shared query:

  1. Sign in to Power BI from Power Query, if you are not already signed in. In Excel, on the POWER QUERY tab, click Sign In. In the Sign In dialog box, click Sign In, and then enter your organizational account information that was used for signing up for 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 your shared queries in Power Query if you are not signed in to Power BI.

  2. In the POWER QUERY tab, click My Data Catalog Queries.

  3. The My Data Catalog Queries pane displays all the queries currently shared by you.

    Point your mouse or click on a shared query name that you want to delete. A data source preview fly out screen displays the shared query. Click DELETE in the preview fly out screen. or right-click > Delete

  4. You are prompted to confirm the delete request. Click Delete again.

Deleting a shared query removes it from the Power BI Data Catalogue, and it is no longer available to the users within your organization. However, the underlying data sources are unaffected when you delete a shared query that is built using these data sources.

Related Topics

Share Queries

View and Update Your Shared Queries

Certify Queries

View Your Shared Queries using the Manage Data Portal

Data Management Experience in Power BI for Office 365 Help

Applies To: Excel 2013, Power BI

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