Export matrix to xls and not csv

[UsePowerBI]

Hello

How can I export the underlying data of a matrix visual in xls so that I do not have the 30k limit of csv?

The save dialog box does not allow me to choose xls, only csv.

Thanks!

[Dinesh_Suranga]

@UsePowerBI 

Hi,

There is no option to export a metrix as excel in Power BI Desktop. But you can export a metrix to excel in Power BI Service.

Thank you.

[VahidDM · Accepted solution]

Hi @UsePowerBI 

Please check these links:
https://powerbi.microsoft.com/en-cy/blog/export-to-excel-improvements-for-table-and-matrix-visuals-p...

https://community.powerbi.com/t5/Desktop/Exporting-a-Matrix-visual-to-Excel/td-p/1643080

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube