Export Dynamic Matrix

[houssemabd]

Hello,

So i'm using PowerBi Desktop.

I have a dynamic matrix that i want to export on Excel (or sql server if it is possible).

The problem that i want to use a button in my report to export the matrix. I found a solution that can export only tables, but i want to export matrix and it's Dynamic ( the number of my columns is variable).

Thanks for the help. 

[v-chenwuz-msft]

Hi @houssemabd ,

As far as I know, exporting to matrix style is not currently supported. Or you can submit your idea to power bi ideas website.

A workaround. you can try use Pivot columns. If you want to do some filters on the table, please insert one step before pivoting table. If the filter is dynamic, please replace the argument with Parameter.

Then load the data to power bi. Copy the table from the data view.

Best Regards

Community Support Team _ chenwu zhu

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

[gauthamboppana]

@houssemabd  -  If you want to export to excel via a button, then youw ill ahve to use Power Automate visual. Please refer this example. 

https://www.youtube.com/watch?v=BnTipbooeP0

https://www.youtube.com/watch?v=sd3YCjN8Co4

Did I answer your question? Mark my post as a solution!

[houssemabd]

The problem that in these videos they are exporting a table, but i want to export a matrix with a variable number of columns.

[gauthamboppana]

@houssemabd  - Hey, you can export an entire report to excel as well usig the Power Automate visual. Another option, if your report only have one Matrix, then you can create a paginated report and user can export the matrix to excel.