It would be excellent to improve the desktop refresh UI.
For large reports it's very hard to track progress and use the information to improve.
- Currently all tables start in "Creating connection in model" which of course they aren't.
- The status icon spinner is spinning for every table until they all finish, of course they're not all busy.
- It's a small non-resizable window, and you have to scroll around to see what's happening.
- Once the refresh finishes, the window closes with no record of what happened.
It would be great to improve the UI:
- Show what each source is really doing - "Waiting", "Retreiving schema information", "Loading data", "Processing loaded data and calculating columns", "Complete".
Change the spinner to show the status - waiting (spinner)/working (something else!)/complete (tick). - Show the start time and completion time for each table (and peak memory used would be a godsend).
- Make the window resizable, scroll to the last udpated status (if the user hasn't scrolled manually elsewhere).
- Don't close the window at the end, allow us to save it to a file (or table), perhaps with even more detailed logging information.
Finally - as many others have requested - I'd love something similar to the above log to be available somewhere for refreshes on the PowerBI service.
1 Comment
- andyclap
Advocate IV
Oh and of course, after loading if the SQL Server Analysis engine runs out of memory processing, all the tables in the refresh show error, with abosolutely no diagnostics or ability to fix things. We need logs!
