Exporting Data

[Strong114]

Hello everyone, 

I cleaned my data using power query on Power BI and I'm having difficulty exporting it to Excel. I will appreciate any help in fixing this. Thanks

[Strong114 · Accepted solution]

I have been able to fix it.

• On Power BI Desktop click “Edit Queries” to open Query Editor
• Select a desired query

Now you have 2 options:

• Click on the tiny table button located on the top left of the table and click “Copy Entire Table”
• Press Ctrl+A to select all columns, then press Ctrl+C to copy data or right click on a column header and click “Copy”. You can select multiple columns by pressing Ctrl and clicking on column headers in case you don’t want to copy the entire table.
• Now you can paste the data to Excel.

Culled from Biinsight.com