Actionable Power BI Reports with an Embedded Commenting App
Food and beverage group, Middle East and North Africa
In short
How can you comment on a single value in a Power BI report?
Management reports need remarks wherever a number deviates, but Power BI's built-in comments cannot target a single value. Finance teams stitched answers together from Excel, PowerPoint, Word and Outlook before every report went out. We built a Power Apps app, embedded in the report, that lets people comment on a specific KPI or date and act on it from the same page.
At a glance
- Comments on a specific KPI or date, not a whole page
- Four actions available from inside the report
- One place for every historical result and comment
The client
The client is a large food and beverage group operating across the Middle East and North Africa. Its finance team produces management reports in Power BI and has to explain deviations, such as overdue invoices, before they go to management.
What it was costing them
- Time: preparing a report meant collecting comments and merging them across several tools.
- Errors: remarks copied between files lose their link to the number they explain.
- Lost history: past comments were scattered across emails and slides, so nobody could see why a number moved.
- Slow follow-up: acting on a deviation, such as chasing an overdue invoice, meant leaving the report.
What we built
We built a Power Apps app with the client's branding and embedded it in the Power BI report, so every comment and action sits next to the number it concerns.
- Comments land on the number: the embedded app lets a user comment on a specific KPI or date, not just on the page.
- A report that looks right: the app is styled to the company's branding and sized to fit each report, unlike the fixed built-in comment panel.
- Overdue invoices chased from the report: an action sends a reminder to the client about selected overdue invoices.
- Answers from outside: an action requests a comment by email from someone who does not use the report.
- Discussion in the right place: an action starts a Teams conversation about a specific result.
- Anomalies approved on the spot: an action routes an unusual result for approval.
- One history: all earlier results and their comments are kept in one place.
- Fewer tools: finance no longer has to assemble remarks from several Office files.
Results
- Comments can be attached to a specific KPI or date inside the report.
- Four report actions are available from the page: client reminder, request for a comment by email, Teams discussion and approval of an anomaly.
- All historical results and their comments are stored in one place.
The risk most teams miss
The month-three risk is that comments outlive their rules. A viewer sees remarks on rows they should not see, the app and the report drift apart after a change, or the connection belongs to one person who then leaves. We carry the report's row-level security through to the comments, run the app on a service account, and test the report and app together with each release.
What we would add today
Improvements we would add on top of what is live.
- Store comments in Dataverse with row-level security that follows the report roles, so viewers see only the comments they are allowed to.
- Add a Copilot Studio agent or Copilot in Power BI to summarise a period's comments and open actions for the finance director.
- Use AI Builder prompts to draft the variance commentary from the numbers, ready for the analyst to edit.
- Deploy the app and report together with Power Platform pipelines, connection references and a service principal.
- Move the report model to Fabric so comments and actions can be analysed next to the figures they explain.
Technology
Power BI, Power Apps embedded in the report, Power Automate, Outlook and Teams.
Tell us which management report your finance team rebuilds in Office every month, and we will tell you how to make it actionable in Power BI.
Products and capabilities
- Power BI
- Power Apps
- Power Automate
- Microsoft Teams
- embedded app
- report commenting
- finance reporting
The service behind this work
Power BIThe service behind this work
Power Platform developmentMore on this industry
Manufacturing and distribution
Related use cases
FinanceWeighbridge Integration and Automated Invoicing for Quarries
At a quarry every load is weighed, but the weight often stops at the gate. When tickets are keyed in again for invoicing, bills go out late, mistakes slip in and stock figures lag behind what has left the site. We linked the weighbridge to invoicing and to a live view of reserves.
Schools Division Integrated Planning in the Accountability Framework App
Each year, the schools division network of the client had to plan business, manpower and finances for all of its schools and centres, in separate spreadsheets that someone had to merge by hand. The cycle had a fixed calendar and a presidential review, so late or inconsistent plans cost real time. We added integrated planning to its existing Accountability Framework app.
- 30+
- schools on shared templates
- c. 90
- departments imported
Bank Reconciliation Proof of Concept for Oracle
Matching bank transactions to finance records by hand costs time every day and ties the process to the people who know the rules. The client was moving to a new Oracle system and asked how reconciliation could work on it. We ran a short proof of concept on its own data.
Have a Microsoft project in mind?
Tell us what you need built, fixed or supported. A senior consultant replies within one business day.