Erik Svensen shows how we can copy queries from Power BI’s Power Query Editor into Excel and back:
Today I discovered a way to easily copy all queries (including the groups) from a PBIX file to Excel without entering the power query editor in Excel.
In my case I needed to copy the data returned by a query and find it some much easier to get the data using Excel instead of generating a csv file from a visual in Power BI Desktop and importing that into Excel.
Click through for a step-by-step demonstration of the process.