Showing results for 
Search instead for 
Did you mean: 
Frequent 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


Frequent Visitor

Thanks - will take a look at your video - but effectively it needs to be an Excel file - but I can review this and see if a csv file will meet the needs of the project.

Post Prodigy
Post Prodigy

Does it have to be XLSX specifically? It is much easier to create a CSV file, which might fit your need depending on what you're trying to do. 

I have a video on creating CSVs that are sent to SharePoint with Power Automate here (this is not a Power BI-specific video but the technique is the same once you have your data in the flow):

Frequent Visitor

No, I never did - had to stick with a template

Regular Visitor

Hi Calvin, I was wondering if you're able to figure out or resolve the issue of adding a row into table in excel.


Alex H.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Kudoed Authors