Gateway Data Refresh Problem

[erhan_79]

Hi there ;

in  my pbix on report page i have a info card  that shows when i refreshed the report and publish.

and it is working via below formula which one created on query side : 

now for refreshing i am using personal gateway and a job is working for refreshing everyday an publishing report.But when system automatic refreshing this info card is not working and stays at the old time that i refreshed before  manually in pbix .

i would like to show with  an info  card on my report refreshed times for automaticly refrehings from gateway too 

Could you pls support me how can i solve this problem 

thanks in advance 

[amitchandak · Accepted solution]

@erhan_79 , refer if this can help

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops

https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/

[V-lianl-msft]

Hi @erhan_79 ,

Try to create a measure with the time.

Date Last Refreshed = VALUES (‘Date Last Refreshed'[Date Last Refreshed])

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.