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.
Community SupportHi 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?
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
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.