Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The Shared Query module in Dataflow Gen2 lets you discover and reuse Power Query logic that other authors share. Browse workspaces, folders, and dataflows, and import selected queries into the dataflow you're authoring. This module is separate from the personal library in Recents & My Queries.
Important
Shared queries is currently in preview. The module might be labeled Shared Query (Preview) or Shared queries. Sharing must be enabled on the source dataflow and on each query you want to reuse. Enabling sharing doesn't grant extra access permissions.
When to use shared queries
Use this module when another author already maintains query logic you want to adapt in your own dataflow. For example, import a standard cleanup query as a starting point, then change the copy to meet your requirements.
If you only want to view a query's results, use its share link instead of importing it. For that workflow, see Consume a shared query.
Before you begin
Open a Dataflow Gen2 that you can edit. You also need access to the source dataflow. The source author must enable sharing for the dataflow and each query you want to import; making a dataflow discoverable doesn't automatically share every query in it.
Browse and import shared queries
- Open the Dataflow Gen2 where you want to reuse the queries.
- On the Home ribbon, select Get data, and then select Shared Query.
- From the Workspaces list, open the workspace containing the source dataflow.
- Browse folders and subfolders as needed, and then open the source dataflow to view its shared queries.
- Select the checkboxes for the queries you want to reuse, and then select Next.
Understand what importing creates
Importing creates independent copies of the queries, not live links to the originals. Editing an imported query doesn't change the source query, and later source changes aren't automatically applied to your copy. Review the imported logic and configure the connections and destinations it needs in your dataflow.
After importing, check for source references and any parameters the logic expects. Test the copied query with your intended data before relying on its output.
If a shared query isn't listed
Check that you're browsing the intended workspace and dataflow and have access to the source. Ask the author to confirm that sharing is enabled for the dataflow and the particular query. Sharing one query doesn't make every query in the dataflow available.
You don't need a share link to browse and import shared queries during authoring. A query's share link opens a separate consumption experience for viewing its results; it doesn't import the query into your dataflow.
For instructions on enabling sharing and its access requirements, see Share queries with other people in Dataflow Gen2.