From every email,
fresh data in Power BI.
Once a month, an email arrives with a CSV attachment. Someone has to download it, save it, upload it to Power BI, check nothing was lost. Then do it again next month.
Hours of routine work. Human error risk. Reports that go stale before anyone opens them. We eliminated all of that for our client, once and for all.
No API, no database,
just an email with a CSV.
The client ran an internal system that could do nothing but send a monthly report as a CSV email attachment. Every month the file had to be manually downloaded, saved, and uploaded to Power BI.
"The system is old, but it works. We don't want to rebuild it. We just need the data to land in Power BI automatically."
Logic App watches the inbox.
Azure Logic App monitors the mailbox and reacts to every incoming email with a CSV attachment.
- Attachment renamed by import date
- Saved to SharePoint in a predefined folder
- M365 ecosystem, no extra licence needed
ADF picks up the file and knows exactly what to do.
Azure Data Factory monitors SharePoint via Graph API. The pipeline identifies which SQL table the data belongs to, tags each row with a period, and loads the CSV.
- Dynamic routing: file → correct table
- Every row tagged with a period
- Optional: validation via Azure Functions
Clean data in Azure SQL, tagged with period.
Every CSV report lands in a structured SQL table. Power BI always knows what is fresh and what is historical.
- Full audit trail, 100%
- Duplicates and data loss eliminated
- Modular, easy to extend
Zero manual work.
Every month, automatically.
CSV arrives by email, Logic App catches it, ADF processes it, SQL stores it, and Power BI displays it. The client does nothing.
- Fully automated data pipeline
- Hours of routine work saved every month
- Zero risk of data loss or duplication
- Power BI reports always up to date, no waiting