Forum Discussion

arthur_gand's avatar
arthur_gand
Frequent Visitor
3 years ago
Solved

Create a new spreadsheet with tables daily using powerbi data

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?

 

2 Replies

  • Hi arthur_gand 

     

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

     

     

    • arthur_gand's avatar
      arthur_gand
      Frequent Visitor

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