How do I export data from Power Query Editor?

Can you export from power query?

4th button on the ribbon ("Output") - press the small triangle under the button and select File. Then press F5. You can write a query against you Power BI data model to extract the data and it has the option to output to file.

How do I save data from Power Query Editor in Excel?

The File Tab1Close & Load – This will save your queries and load your current query into an Excel table in the workbook.2Close & Load To – This will open the Import Data menu with various data loading options to choose from.

How do I get data from power query?

Import data with Power Query (Get & Transform)1Go to Ribbon > Data > Get Data > From File > From Workbook.2Power Query displays the Import Data dialog box.3Identify the source workbook and double-click on it.4Power Query displays the Navigator dialog box.5Select the data source you want to work with.6Click Load.