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