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 , 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.