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 UserKeep in mind that the Power BI Service runs on UTC. What is your timezone?
Hi Ibendin, my Timezone is BST, should this affect the data being displayed?
Just a quick tought, could this be as a result of the Time change that happened in the UK a few days ago?
v-hashadapuCommunity Support
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.