Anonymized engagement summary: fixing Power BI Report Server data refresh from Project Online, assessing the Power BI environment and training IT staff, for an agribusiness (2021)
Anonymized engagement summaryLarge agribusiness · 2021
Opening answer. A large agribusiness ran its BI and reporting on an on-premises Power BI Report Server. Its data refresh from Project Online had broken. In 2021 the company engaged EPC Group to:
- troubleshoot and fix the refresh by evaluating the OData connection between Power BI and Project Online, recommending fixes and making the changes so refresh runs automatically
- assess the wider Power BI environment against business goals and best practice: data model and architecture, existing reports and dashboards, and the report server itself
- deliver a customized training program for the in-house IT staff
- provide subject-matter expert support
This is an anonymized engagement summary published under EPC Group's anonymized-engagement rule: the client is not named, no commercial terms are published, and every statement is EPC-reported. Named, documented engagements are in the Evidence Center.
Problem and scope
| Item | Scope |
|---|---|
| Organization | A large agribusiness |
| Situation | An on-premises Power BI Report Server used for BI and reporting, with a failing data refresh from Project Online |
| Fix | Evaluate the OData connection between Power BI and Project Online to find the problem; recommend changes; carry them out to restore automatic refresh |
| Assessment | Establish business goals and end-user requirements; evaluate the data model and architecture; assess existing reports and dashboards; review other aspects of the report server |
| Training | A customized program on the company's own environment and data, so in-house IT staff can make full use of Power BI with minimal outside help |
| Support | Subject-matter experts for further questions and requirements, with technical guidance as needed |
Not reported: the root cause found, the number of reports, user counts and any measured result.
Approach and artifacts
Fix the pipe, then look at the whole system. The refresh failure between the report server and Project Online is diagnosed and fixed first, then the rest of the Power BI environment is assessed against best practice.
Train on the client's own reports. The training program is built around the company's environment, data and reports rather than generic material.
What EPC Group delivered and what is not claimed
| Claim | Basis | Status |
|---|---|---|
| The company contracted EPC Group to fix the report-server refresh from Project Online, assess its Power BI environment and train IT staff | EPC engagement record | Contracted (EPC-reported) |
| Refresh restored, recommendations adopted, or measured results | Not reported | Not claimed |
Related services
Power BI consulting · All case studies · Talk to a senior architect
Last updated by Errin O'Connor, Founder & Chief AI Architect, EPC Group
Related service: Power BI Admin & Governance Support Services
Author: Errin O'Connor, Founder & Chief AI Architect, EPC Group · Published October 25, 2026 · Project alias EPC-2021-ANON-AGRI-PBIRS · Published under the anonymized-engagement rule.