DEV and PRD Usage, Expectations & Accountability Audience: Analysts, Report Authors, Data EngineersApplies to: Common Data Model (CDM), Data Marts, Power BI reportingPurpose: To ensure shared understanding of how data environments are intended to be used, and to protect confidence in reporting. 1. Purpose of Separation The separation between DEV (Development) and PRD (Production) environments … Read more
🧾 Incident Summary: Discrepancies were identified between the Headcount report and the Management Accounts (MA) reporting figures. The headcount submission process also suffered from data entry issues, retrospective updates, and manual effort required to maintain alignment across periods. 🔍 Root Cause Analysis 1. Inconsistent Timing of Submissions 2. Differences in Ownership and Definition 3. Submission … Read more
📌 Key Takeaway: Always use Web.Contents() when connecting to authenticated web resources or APIs, especially if publishing to the Power BI Service.Reserve Web.BrowserContents() for desktop-only scenarios like scraping HTML pages with dynamic content — and expect no scheduled refresh capability. ⁉️ Scenario We encountered a frustrating authentication issue when trying to refresh a published Power … Read more