Skip to main content

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

ItemScope
OrganizationA large agribusiness
SituationAn on-premises Power BI Report Server used for BI and reporting, with a failing data refresh from Project Online
FixEvaluate the OData connection between Power BI and Project Online to find the problem; recommend changes; carry them out to restore automatic refresh
AssessmentEstablish business goals and end-user requirements; evaluate the data model and architecture; assess existing reports and dashboards; review other aspects of the report server
TrainingA 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
SupportSubject-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

ClaimBasisStatus
The company contracted EPC Group to fix the report-server refresh from Project Online, assess its Power BI environment and train IT staffEPC engagement recordContracted (EPC-reported)
Refresh restored, recommendations adopted, or measured resultsNot reportedNot 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.

AI assistant — not a human