topic Re: Power BI report missing some Data when published to Power BI service in Service

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

KabeerO — Tue, 31 Mar 2026 16:03:47 GMT

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

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

ibarrau — Tue, 31 Mar 2026 20:18:44 GMT

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,

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

lbendlin — Wed, 01 Apr 2026 00:02:00 GMT

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

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

KabeerO — Wed, 01 Apr 2026 08:04:24 GMT

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

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

KabeerO — Wed, 01 Apr 2026 08:07:52 GMT

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

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

KabeerO — Wed, 01 Apr 2026 08:33:03 GMT

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

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

v-hashadapu — Wed, 01 Apr 2026 10:24:40 GMT

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.

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

v-hashadapu — Mon, 06 Apr 2026 05:42:22 GMT

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.

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

KabeerO — Tue, 07 Apr 2026 08:09:40 GMT

Not yet. I still can't find how to work around the Time bucket Problems. Any help will be appreciated.

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

v-hashadapu — Tue, 07 Apr 2026 08:30:55 GMT

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?

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

KabeerO — Tue, 07 Apr 2026 08:37:16 GMT

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?

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

v-hashadapu — Tue, 07 Apr 2026 11:18:36 GMT

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.