Fix Data Discrepancies in Power BI

I already have a fully-built Power BI report that pulls our Balance Sheet and Profit & Loss, but some numbers are off. I’ve traced the issues to data discrepancies in the Assets and Liabilities sections of the Balance Sheet and similar discrepancies flowing through to the P&L.

Here’s what I need from you:

• Open the existing .pbix, trace the data sources, queries, and measures, and identify why the Assets and Liabilities figures are wrong.
• Apply the same rigorous check to the P&L so every figure aligns with our source ledger.
• Once everything reconciles, deliver a clean, version-controlled .pbix file with all discrepancies fixed and clearly documented.

I work in a standard Microsoft stack (SQL Server + Excel feeds), so familiarity with Power Query, DAX, and basic accounting structure is essential. No visual redesign is required—just rock-solid numbers that match the ledger.

I’ll provide the current .pbix, sample source files, and ledger extracts the moment we start. Let’s get the figures spot-on so the finance team can rely on the report without second-guessing the data.