Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to export a matrix visual from Power BI to Excel online via Power Automate. I have done this before using the approach described in the video below. However, this approach doesn't work this time because in the matrix there is a complex measure (involving 2 fact tables, vars, 3 calendar slicers) which I can't embed in selectcolumn() query. As a result, I can only export the data via a Power Automate button which means I have to click the export button every Friday.
Is there a solution to solve this problem? Basically I want to run a scheduled Power Automate flow, but the flow should allow me to export complex measures.
Automatic exports of Power BI data 🤖 | Run a query against a dataset
Hi @Jeanxyz
Did you try to achieve it with the paginated report and run your flow against it?
I didn't use paginated report. I want to create a Power Automate flow to schedule the data export.
I got it...you said that is doesnt work...just tried to sudgest some other alternative...
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |