Issue - Table export to excel

[Anonymous]

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 data. Is it possible to control c + control v the table below or just export it in  excel directly?

Thanks

[v-piga-msft · Accepted solution]

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]

Hi @Anonymous ,

Give it a try from Power BI Service.

Regards,

Fernando

[Anonymous]

Hi @calerof 

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

[calerof]

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