Count down timer that shows the time spent on a dashboard

[Nick-Singleton]

I need a visual that is a count down timer that show the time spent on a dashboard.  The "countdown" visual does not work because it needs to be dynamic.  In other words, as soon as the dashboard is loaded, it starts counting down from 30 minutes.

The reason I need this is I have a NetScaler in front of Power BI Report Server.  After 30 minutes, NetScaler will time-out the session.  The problem is the user isn't notified anything.  So it is confusing for the user.  How can I solve this problem?

[AiolosZhao · Accepted solution]

Hi @Nick-Singleton ,

I have a workaround that can help you, hope that's what you want.

Because according to your requirement, I think what you want is an end-time based on the report refresh time. 

So if there is an end-time that can show in the front-end in highlight, I think that also will be suitable for you.

So you can create a new column in Power Query Editor like below, then you will get the refresh time + 30 min.

Then you can show it in the highlight in the front-end, then end-user will know when the report will be a time-out.

DateTime.FixedLocalNow() + #duration(0,0,30,0)

Aiolos Zhao

[Nick-Singleton]

This is a great idea.  However, I can't implement this because all our dashboards use a live connection to SSAS.  As far I know, you can use Power Query and Live Connection to SSAS.  Is that correct?