Recently, I started a project where I want to use power automate to help run script on newly downloaded csv file to clean it up, save that file, and then create a Power BI report through that clean-up file. However, I am having a tough time trying to create a flow.
Also is it better to create the flow in the browser or desktop version?
Basically, these are the steps that I want to implement in the flow:
- Download .csv file through Blackbaud
- Save in Sharepoint
- Run script on the file and save as excel file
- Import the excel file through Power BI
- Save the Power BI report and receive an email notification
A new report file will be downloaded every week with different naming based on the date. The pics that I attached are what I can come up with they’re giving me an error.
Please help, thanks in advance!


Report
All responses (
Answers (