Forum Discussion

cah2035's avatar
cah2035
Frequent Visitor
6 years ago
Solved

Copying data table from Power BI/Query to Excel

Hello,    I have transformed by data using Power Query and am trying to copy the data to Excel by loading it to Power BI, right clicking on the table in the list, and selected "Copy Table". When I ...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi cah2035 , 

    I test this in my environment, which could work well. You could click like below, then paste this in Excel.

     

    By the way, I think Analyze in Excel is more like a add-in tool which help open or connect dataset from powerbi service and analysis this in Excel. You could refer to service-analyze-in-excel for details.

    Best Regards,
    Zoe Zhi

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

MadsD's avatar
MadsD
Advocate I
1 year ago

Sometimes with this option it will only copy paste the first 1.000 rows. Is there a way to copy paste entire table? IF for example I have 45k rows.

lbendlin's avatar
lbendlin
Super User
1 year ago

This is a very old post. Power Query in Excel is now very close to feature parity with the one in Power BI. No need to copy/paste the data any more - copy/paste the query.