The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Hi @RGL ,
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
Hi @RGL ,
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 Regards
Lucien
Hi @RGL
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?