Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Issue - Table export to excel

Hi Guys   I did a kind of Pivot table on Power BI which I need to export on excel but it does not allow me. It allows me to export into CSV file which I try to open in excel but it messes the whole...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous ,

    Actually, we could export data via csv in Power BI Desktop and open it in Excel.

    If you want to export as excel format directly, you could publish your report in power bi service and click export data option, there are two options for you choose, you could select excel and export it.

    In addition, you could refer to this document or this video which should be helpful.

    Best  Regards,

    Cherry

     

calerof's avatar
calerof
Impactful Individual
7 years ago

Hi Anonymous ,

 

Give it a try from Power BI Service.

Regards,

Fernando

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi calerof 

     

    Sorry it stil does not work. What do you mean by Power BI Service?

    • calerof's avatar
      calerof
      Impactful Individual
      7 years ago

      Hi Anonymous ,

       

      When you sign in to powerbi.com instead of to the desktop. You've had to published your report first.

       

      Kind regards,

       

      Fernando