Forum Discussion
Power BI report missing some Data when published to Power BI service
I have a powerbi report for my contact center that shows agent activities in a 30 minutes time bucket throughout the day, on power bi desktop, when i do a manual refresh, all data for all time shows, but when i publish to service, after a little while, the last hour of yesterday goes missing. if i download this report, refresh in power bi desktop again and publish, it is fine till the next refresha and then it fails again, missing only the last hour of yesterday and today
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.
11 Replies
- ibarrau
Super User
Hi. 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
- lbendlin
Keep in mind that the Power BI Service runs on UTC. What is your timezone?
v-hashadapuCommunity Support
Hi KabeerO , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.
Not yet. I still can't find how to work around the Time bucket Problems. Any help will be appreciated.
- v-hashadapu
Hi KabeerO , have you tried using UTCNOW() (with the correct offset) or adjust it in Power Query so both Desktop and Service evaluate time consistently. Can you please confirm?
