Create a flow to run office script when new filed is created then create report in Power BI

(0) Share

Report

Posted on by MD-01111700-0

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.

Please help, thanks in advance!

Categories:

Business Process Flows

Pic 2.jpg

Pic 1.jpg

All responses (1)

Answers (0)

lbendlin 7,835 on at

Like (0)

Report

Create a flow to run office script when new filed is created then create report in Power BI

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.