Forum Discussion

Jeanxyz's avatar
Jeanxyz
Icon for Power Participant rankPower 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

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    3 years ago

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

    • Jeanxyz's avatar
      Jeanxyz
      Icon for Power Participant rankPower 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
        Icon for Super User rankSuper User
        3 years ago

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