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 f...
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

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