Create a new spreadsheet with tables daily using powerbi data

[arthur_gand]

Hello all,
Today I get 4 spreadsheets and feed my Powerbi (as in print).
I needed that automatically, every day at 08h a.m. the powerbi create in the sharepoint of my company an excel file, with the tables.

I searched and the only solution so far is the "Run a query against a dataset", but this is not available in my power automate, is there any other way?

[GilbertQ · Accepted solution]

Hi @arthur_gand 

You should be able to use Power Automate, can you find this one as shown below?

[arthur_gand]

I managed to find the option, now I need to make it overwrite all rows of my excel, whenever I do the update