schedule automatic data export from Power BI to Excel

[Jeanxyz]

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

[Ritaf1983]

Hi @Jeanxyz 
Did you try to achieve it with the paginated report and run your flow against it?

[Jeanxyz]

I didn't use paginated report. I want to create a Power Automate flow to schedule the data export. 

[Ritaf1983]

I got it...you said that is doesnt work...just tried to sudgest some other alternative...