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

     

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
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