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

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