Appreciate if anyone can assist here as I have been struggling to get my head around this for weeks.
I am pulling a data set through an API from our Service Desk managament system which provides dates in ISO-8601 format. I am in the UK and our timezone is set to London/GMT. When I convert the data in power query (change type) to date and time they are correct. However performing the same in PowerBi Service the data is one hour behind so causes the stats to be incorrect especially as we need to show the rate of calls per hour.
I understand that the PowerBi service uses UTC which is the same as GMT so should not be an issue for us in the UK. If I publish the data from Desktop to Service then it is correct but as soon as they PowerBi performs a refresh throught he api the date is incorrect again by one hour.
Going crazy on this one so appreciate any guidance/advice please.