Forum Discussion
Power BI report missing some Data when published to Power BI service
Hi KabeerO , Thank you for reaching out to the Microsoft Community Forum.
When I mentioned UTCNOW(), I meant updating your model logic, not the Service setting. You need to explicitly control the timezone in your calculations, for example by replacing NOW() with UTCNOW() and applying the correct offset or by converting your datetime column in Power Query (e.g., shifting UTC to BST). This ensures both Desktop and Service evaluate time the same way and prevents that missing hour issue.
Super UserHi. Make sure the visuals don't have a hidden filter. Mouse over a visual and check filters just in case there is a relative time/date filter preventing that to show and when refresh occurs it's fixed. Compare service with desktop.
If you can't find anything, make sure it's not cache. Sometimes when you keep many cookies and storage at a browser, after a refresh is run, you open the report and it shows the old data. Click at the refresh visuals button on top right of the report or Shift+F5 the browser to check if that fixes it without a republish.
I hope that helps,
The only filter the visual has on is the time bucket being filtered to show only working hours i.e 9am to 6pm otherwise no filter is on the visual
