Forum Discussion

erhang's avatar
erhang
Helper II
8 years ago
Solved

Refresh Date To Report

Hi there ;   İs there anyway to put " the refresh time of report "into the dashboard of the report.İ want that when i refresh the report at the corner of dashboard refresh time will seem.   Thank...
Need Help
  • prateekraina's avatar
    prateekraina
    8 years ago

    Hi erhang,

     

    One way would be to create a calculated column in the model to store current Datetime.

    Build a card visual to show the Datetime value inside report somewhere.

    Then pin this card to the dashboard along with other required visuals.

     

    Make sure you create calculated column and not measure, because the value needs to refresh only when dataset is refershed which is achieved by calculated column.

     

    Prateek Raina

prateekraina's avatar
prateekraina
Memorable Member
8 years ago

Hi erhang,

 

One way would be to create a calculated column in the model to store current Datetime.

Build a card visual to show the Datetime value inside report somewhere.

Then pin this card to the dashboard along with other required visuals.

 

Make sure you create calculated column and not measure, because the value needs to refresh only when dataset is refershed which is achieved by calculated column.

 

Prateek Raina

  • erhang's avatar
    erhang
    Helper II
    8 years ago

    Thank you prateekraina for your support 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi

    I am getting data from VSTS using online services connector and have created a calcuated column based on current time.

    The refresh date is fine when i do the referesh from desktop as it takes local time, but when the report is refreshed in power BI service it gives the date in UTC format.

    Any pointers how it can be converted to local time zone.