I've seen posts about this, but couldn't find the appropiate solution for this. I have a card which shows my last refresh date, i did it doing the following:
'' Last refresh column = NOW() ''
Then i use this measure in the card:
'' Last refresh date = MAX('tbl_sales'[Last refresh column]) ''
Everything works fine in desktop. But when i upload the report onto Service it shows the last refresh time - 1 hour. So instead of 11;00 it would show 10;00. Does anyone have any idea on how to fix this?