
Announcements
Here's my ideal scenario with the pieces that I already have in place and the piece I'm missing:
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.
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.