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.