Forum Discussion
Data refresh not showing in report
I have a report with scheduled refresh four times a day. During the day it works fine, but from time to time it won't refresh in the first schedule of a new day.
As shown in the image, the data does update (blue circle), but it doesn't reflect on the report (red circle)
What could be happening?
3 Replies
- GilbertQ
Super User
Hi Anonymous
Could it be that one date if from the dataset date/time while the Power BI Service is the the time the actual dataset got refreshed and that is why they are different?
- v-luwang-msft
Community Support
Hi Anonymous ，
On Power BI Service, the now() function will return the UTC time and TODAY() function on Power BI service returns today value by GMT timezone. We can't set the time zone on Power BI Service. To get the correct local time, we can add time different in your DAX formula, or use Power Query to get the local time zone datetime. For more details, please see:
Solving DAX Time Zone Issue in Power BI.
Resolving Timezone Issue on Power BI service
And not clear what measure you used by Power BI desktop,could you pls share me how to get the time in your report?
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
- v-luwang-msft
Hi Anonymous ，
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
