Forum Discussion
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 data. Is it possible to control c + control v the table below or just export it in excel directly?
Thanks
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
4 Replies
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
Hi Anonymous ,
Give it a try from Power BI Service.
Regards,
Fernando
