Hi, I am new to power automate and have been trying to understand how it works.
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.
Why not use an existing Power BI semantic model and report? Your flow could simply refresh that when the new CSV arrives. The cleanup can be part of the Power BI refresh.
Was this reply helpful?YesNo
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.
Share
Report
All responses (
Answers (
8,551
