Find And Use Shared Queries Power Query. The source dataqueries will not be sent with the pivot table files but will be connected to those queries. By default all project members and users with Stakeholder access can view and run all shared queries.
You can use Add column ribbon of Power Query to do such operations. To add and save a query under Shared queries you must be granted Basic access or higher. The location is shown in the picture below.
When you find and use a shared query in Power Query the query definition is downloaded to the current workbook and executed in Excel to import the data referenced by the query into the workbook.
From the dropdown menu select the Copy option. And you will see a list of functions from which you can click the function and see a detailed description along with its parameters. You can find and use a shared query to use the underlying data in the queries for data analysis and reporting. What is the best way to set this up.