web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Help: Update File Cont...
Power Automate
Unanswered

Help: Update File Content of .csv for Use with Power BI

(0) ShareShare
ReportReport
Posted on by 83

Here's my ideal scenario with the pieces that I already have in place and the piece I'm missing:

  1. Automated delivery of .csv to email from external platform
  2. Flow to save and rename .csv to OneDrive
  3. Flow to update a second .csv with the contents of the first .csv (Power BI won't refresh the first .csv if I overwrite it every time)

I can't use the update row flow as that requires the emailed file to be formatted as a table. Looking to use the Update File Content action if possible. 

Categories:
I have the same question (0)
  • takolota1 Profile Picture
    4,974 Moderator on at

    @dedgerton1 

     

    You could convert the original Power BI CSV to an Excel workbook file & connect Power BI to that. (The only reason I can think you wouldn’t do that is if there was too much data, in which case I suggest transferring it to a SharePoint list or SQL datatable.)

     

    Then use the CSV to JSON template to routinely get the CSV data from the email: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/td-p/1508191

     

    And use a Create row or Add row action to add the new CSV data from the email to your original file’s table.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard