A manager wants real-time data, but the source system refreshes only once a day. What do you do?

< 1 min read

First, I clarify the manager’s actual requirement and understand why they need real-time data.
I check what decision depends on real-time visibility and how frequently it must update.
Then I explain the current system limitation that the source data refreshes only once a day.
I present realistic alternatives, such as near real-time updates or hourly snapshots if technically possible.
In one project, we provided a daily dashboard with a clear “Last Updated Time” to avoid confusion.
If real-time is critical, I discuss with the data engineering team about enabling streaming or API-based updates.
I also evaluate the cost and effort required for infrastructure changes.
Finally, I align expectations with stakeholders and propose the most feasible solution.

Power BI Essentials