export data from power bi visuals to excel automatically

Hi! Again disclaimer that I am not 100% well versed in the steps. You may need to watch a couple Power Automate videos to finish off the steps. Here are some ideas that could work:

If you can live with a CSV output with each run, then you could grow the Power Automate flow executing 3x "run a query against a dataset", once for each table. Then assign a naming convention+timestamp and drop the CSVs into the destination of your choice.

The trouble I've had with creating an excel file specifically is Power Automate wants an already established table to fill in your content. You could make excel files with tables ahead of time, and include a timestamp column. Then put your content into that table and include the timestamp so you can track it all. 

I got tired of parsing CSVs, so I've since moved to SharePoint lists. I am doing mostly the same thing, but the catch is I need to have all of my columns defined ahead of time. SharePoint Lists are also great to pull into PowerBI reports so I've been doing this as much as possible.

I added a new step after the query: Parse JSON. The parse is super helpful to already sort my content into columns. Then I retrieve my SharePoint List (Get Items) and Create Item, looping through everything I pulled. The parse JSON is going to want an example payload, which I know nothing about. So what I do is, run the query database flow, and copy the output of that. Paste it into the example payload for Parsone JSON and it should figure itself out! 🙂