Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Exporting from Power BI Desktop into Excel Workbook

Currently, if using the Power BI Desktop, you can only export to Excel using the CSV format.  However, if the PBI report is published, online you can export it using the XLSX format.  How do we export data in Desktop to XLSX, and if we cannot, please add this to the Ideas.

Additionally, is it possilbe to export the data to look the same as it does in the dashboard?  IE column formatting/colours, conditional formatting, etc.

Status: Investigating
Comments
v-robertq-msft
Community Support

Hi, 

According to my research, this is by design in the Power Bi desktop. I suggest you to use this online tool to simply convert the CSV file you exported to XLSX to achieve your requirement:

https://convertio.co/csv-xlsx/

 

If you have an idea to help to improve the PowerBI, you can go to the Power BI Idea to submit a new idea so that people with the same idea can vote for you. I will also vote for you.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

v-robertq-msft
Community Support
Status changed to: Investigating
 
schnarf78
Frequent Visitor

Hi Robert,

I thought this was already posted in Ideas. Was that not the case?

Thanks for the tip on how to convert a CSV to XLSX, but that's not my issue. As I can get it in XLSX from the Online report, I don't understand why the desktop version is limited to CSV.

v-robertq-msft
Community Support

Hi,

According to my research, I suggest you to vote on this idea because in this idea many customers have the same idea as yours and it seems to be hopeful.

https://ideas.powerbi.com/ideas/idea/?ideaid=86a6fd2c-55eb-4204-83a2-bd31b497274d

 

Best Regards,

Community Support Team _Robert Qin