Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper II
Helper II

GMT time issue in Power BI service



I have a dataset from a sql server where the times are showing correct in Power query editor and my pbix file. 


The date and time field is already converted to GMT using sql and power query changes the column to type date/time/timezone.  I then convert this to date only and in data model I use this field in my date table relationship. I also have a custom column using Time.Hour to get the hour element from the date/time/timezone field and convert this to text.


If I publish to the service the times remain ok but as soon as I refresh directly in the service I loose the 23:00 time element from my table and all time fields shift by 1 hour.


For example 07:00 data becomes 08:00 data etc.








Any idea how I can overcome this?



Helper II
Helper II

Hi, after spending the last month on this I am still no further to finding a solution having tried various time zone conversions in both Power Query and dax.




If you look at my example above it is fine till 00:59 on 27/03.  In power query this is absoluttley correct as there are no times between 01:00-02:00 as this is the hour we lose for British Summer Time.  In my pbix file this is also correct but the issue occurs when I publish to the service where everying after 00:59 is 1 hour out.  


I think what I need to do if possible is to create another date column and increment the instances where the timezone is already +01:00:00 (British Summer Time) which will be one hour out in my pbix but then correct in the service?



Hi @Trebor84 


Check this link:


If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!




FIFA Word Cup Medal Records Dashboard:

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors