Problem:
When loading or refreshing queries in Power BI Desktop, the current Load dialog only shows vague statuses like “Evaluating” or “Waiting for other queries”. This makes it difficult to understand:
How much time is left before the refresh completes.
Which specific step of a query is currently running.
Which queries are blocking others due to dependencies.
Where performance bottlenecks occur during load.
As a result, users are often left waiting without insight into what is happening behind the scenes.
Proposed Solution:
Enhance the Load / Refresh progress UI with more detailed and actionable information:
Progress Indicators
Show an estimated time remaining for each query (like SSIS or SQL import tools).
Display percentage progress per query.
Step-Level Tracking
Indicate which transformation step (e.g., Filtered Rows, Expanded Columns) is currently being executed.
Provide duration per step after completion for performance tuning.
Dependency Visualization
Show a small dependency tree (which query is waiting on which).
Highlight blocked queries with their blockers.
Resource Monitoring
Optional display of CPU / Memory usage during refresh to identify bottlenecks.
Detailed Logs (Exportable)
Allow exporting refresh logs directly from the UI for troubleshooting.
Benefits:
Improves user confidence during long refreshes.
Makes debugging query performance easier.
Reduces wasted time waiting without knowing if a query is stuck.
Provides transparency into dependencies between queries.
