Forum Discussion

Jeanxyz's avatar
Jeanxyz
Power Participant
3 years ago

schedule automatic data export from Power BI to Excel

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

Need Help

3 Replies

    • Jeanxyz's avatar
      Jeanxyz
      Power Participant
      3 years ago

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

      • Ritaf1983's avatar
        Ritaf1983
        Super User
        3 years ago

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