Power BI report missing some Data when published to Power BI service

[KabeerO]

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

[v-hashadapu]

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.

[KabeerO]

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?

[KabeerO]

Yes, I have set it to (UTC) Dublin, Edinburgh,Lisbon,London

but still not working.

When you say adjust in Power Query, what do you mean by this?

[v-hashadapu · Accepted solution]

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.

[lbendlin]

Keep in mind that the Power BI Service runs on UTC.  What is your timezone?

[KabeerO]

Hi Ibendin, my Timezone is BST, should this affect the data being displayed?

[KabeerO]

Just a quick tought, could this be as a result of the Time change that happened in the UK a few days ago?

[v-hashadapu]

Hi @KabeerO , Thank you for reaching out to the Microsoft Community Forum.

Yes, I think this is due to the recent UK time change. Power BI Service runs in UTC, while Desktop uses your local time (BST). Because of the DST shift, your yesterday and time bucket logic is now off by an hour in the Service. That’s why the last hour disappears after refresh, it’s falling outside the evaluated range in UTC.

You’ll need to handle time explicitly, either use UTCNOW() (with the correct offset) or adjust it in Power Query so both Desktop and Service evaluate time consistently.

[ibarrau]

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,

[KabeerO]

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