Forum Discussion

masplin's avatar
masplin
Impactful Individual
9 years ago
Solved

export data to excel

I'm struggling to decide whether to move from excel based models to PBI Desktop models. There are number of issues, but a key one is how to export large chunks of underlying model data e.g. customer ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi masplin,

     

    Thanks for your suggestion. It's true that export to CSV is only available in service rather than Power BI desktop now. For your requirement, you can vote this idea: export excel.

     

    Best Regards,
    Qiuyun Yu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

If you are in the PBI Desktop, you can go to the Data View and right click on any table name.  On this menu is an option "Copy Table" which attempts to put that table into your clip board.  Larger tables will have a "Please Wait" message.  Once this is done, you can simply paste into your Excel.

 

I've done this for a few audits.

rcmmonteiro's avatar
rcmmonteiro
New Member
8 years ago

The simpler and best solution. Thanks!