Forum Discussion
houssemabd
4 years agoFrequent Visitor
Export Dynamic Matrix
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 ma...
v-chenwuz-msft
4 years agoCommunity Support
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.