Forum Discussion
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...
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!
The problem that in these videos they are exporting a table, but i want to export a matrix with a variable number of columns.
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.