Power BI Reconciliation Automation

I need an expert who can take raw CSV/Excel exports from my Flipkart account and turn them into a fully-automated Power BI solution. When I hit Refresh, the model must ingest each file, clean and relate the tables, and instantly show accurate reconciliations for three critical areas:

• Payments
• Order returns
• Delivered orders

The underlying data is messy—multiple tables, inconsistent headers, overlapping IDs—so advanced Power Query shaping, robust data modelling, and precise DAX calculations are essential. I also want sensible error handling: if a column name changes or a file is missing, the report should flag it clearly instead of breaking.

Deliverables
• A PBIX file with queries, relationships and measures already set up
• Step-by-step documentation on where I should drop new CSV/Excel files and how the scheduled or manual refresh will work
• A brief hand-off call or video walkthrough to confirm everything reconciles correctly against a sample month of data

If you have experience taming large ecommerce datasets in Power BI and can demonstrate past projects of similar complexity, let’s get started.