Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Export PowerBI Data to Excel using Power Automate

Struggling to get this to work when trying to create a new file. It works fine if I have an Excel template already set up. However when I try to create a new spreadsheet based on a template (so with the same Table name etc) I get errors.


Using "Get File Contest using path" and then "Create File" - both these work and a new file is created in the right place.


But my "Add a row into a table" does not 



I am having to custom code the Table name - as it does not know it. But using the correct table name.

 Getting this error


  "message""A value must be provided for item.\r\nclientRequestId: 17006e0c-ce6e-4d34-a6d5-02cc6346b6ca",
  "error": {
    "message""A value must be provided for item."


I am stumped - based on Youtube video from @rezadorrani



Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Kudoed Authors