Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How do I get the current date on Power BI dashboard without refreshing it on service?

Hi,

 

Is it possible to get the current date and time on dashboard/report of power BI Service without requiring it get refreshed every minute.

 

I checked for Dax function NOW() and power query function too, but all of that shows stale data on service if data set not refreshed.

 

Looking for something real time and not stored, can anyone help on this.

 

Thanks 

Varshada

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Thanks Fowmy  AbhiSSRS  for your response and suggestions.

     

    I think I may have found a workaround for my requirement.Earlier ,I  tried with Calculated column for current date but since it stores the data in the Power BI memory, we always see stale data as of last refresh time.

     

    Now , I tried with Calculated measure which dynamically calculates values (no storing calculation in cache), it worked !!

     

    I do require to refresh the page, but that is still acceptable, better than refreshing entire dataset .So when the user lands on the dashboard he/she can view the latest time.

     

    I have voted for the idea mentioned in your response-  https://ideas.powerbi.com/ideas/idea/?ideaid=c6593d3a-f8d9-42cb-a970-cc356491095e

     

    Thanks

    Varshada

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks Fowmy  AbhiSSRS  for your response and suggestions.

     

    I think I may have found a workaround for my requirement.Earlier ,I  tried with Calculated column for current date but since it stores the data in the Power BI memory, we always see stale data as of last refresh time.

     

    Now , I tried with Calculated measure which dynamically calculates values (no storing calculation in cache), it worked !!

     

    I do require to refresh the page, but that is still acceptable, better than refreshing entire dataset .So when the user lands on the dashboard he/she can view the latest time.

     

    I have voted for the idea mentioned in your response-  https://ideas.powerbi.com/ideas/idea/?ideaid=c6593d3a-f8d9-42cb-a970-cc356491095e

     

    Thanks

    Varshada

  • AbhiSSRS's avatar
    AbhiSSRS
    Icon for Solution Sage rankSolution Sage
    5 years ago

    The closest you can get is a clock as web-content on a dashboard with report .