Forum Discussion
As Visual Refreshes the Data - Give User Message or Visual to Prevent Use
I have a report that takes the visual about a minute to refresh as the data is directly linked to the SQL database. As the report refreshes, you can see a small refresh circle at the top left of the visual. Is there anyway to make that more noticable for the user? I am completetly open to any suggestions on a way to accomplish this - i.e. another visual that is only shown while the other visual refreshes, a way to prevent clicking until it is done, make the spinning circles in the top left corner more noticable, ect.
2 Replies
Think about using a hybrid model where the query for this particular visual is either done via an aggregated table. or especially optimized through indexes on the server side.
Any wait time above five seconds will lead users to abandon your report.
Thanks for the note - it got me rethinking the way the data was coming together. Orignally I was joining really large datasets together in Power Query. I removed that step and create a new table that uses the Union funtion. It went from over a minute to refresh the visual to about 2 seconds.
