move a table from Power BI to Excel

[lastnn30]

Hi

In Excel Power Query, I can "Close and Load" power query and load the table back to excel. Can I do the same thing with Power BI? I have 3 tables. I appended them using Union Dax (thanks for your help) and now I have this big table. I wonder if I can move it back to excel and work on it from excel?  Thank you very much.

[Vijay_A_Verma · Accepted solution]

Easiest way is right click on union - Copy table - Do CTRL+V in Excel. 

[v-henryk-mstf · Accepted solution]

Hi @lastnn30 ,

Depending on your needs, you can create the table after union as table visual, then select the three dots in the upper right corner and choose export data. then you can open it in excel.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Vijay_A_Verma · Accepted solution]

Easiest way is right click on union - Copy table - Do CTRL+V in Excel.