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.

  • masplin's avatar
    masplin
    Impactful Individual
    9 years ago

    Hi Ross

     

    not quite what is needed. I need ot produce listsof say filters cusotmers, but with detial from related tables or similar corss table lists for finance often hundreds or thousands of rows. In Excel I can either just write a DAX SUMMARIZE function to createa table or do a tabular pivot table. 

     

    While I can create a table in Desktop I can only export as CSV which the fiance/marketing people woudl have to reformat to make use of.  I could publish everything up to Service and export as Excel, but that again is not great for doing ad hoc queries.

     

     Weird that you can't export Desktop directly to excel as you can from Service.  So for this type of output excel seems significanty superior. 

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      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

      • masplin's avatar
        masplin
        Impactful Individual
        9 years ago

        Oddly it is the other way round. Desktop can only export csv whereas service can export to xlsx

  • rcmmonteiro's avatar
    rcmmonteiro
    New Member
    8 years ago

    The simpler and best solution. Thanks!