Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Incremental refresh time zone - Power BI service

Hi all

 

I seem to be having issues with timezone when incremental refresh is applied to my dataset. 

 

I am located in New Zealand and incremental refresh appears to be around 12 hours behind (GMT Time). I have the data load daily and for yesterdays sales it only generates small amount of sales. i.e. Wednesday 26th August only showing 144k in sales where it should be over 1mil. 

 

Does anyone know how to fix this so the full Wednesday loads? I think it's a timezone difference of 12 hours causing the issue when i use incremental refresh. As you can see the incremental refresh data doesn't align with the posting data, this only happens after incremental refresh. I look in power query and filter for specific posting date the incremental date is the same.

 

 

Anyone help would be awesome!

 

Thank you

 

Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You can use DateTimeZone.SwitchZone function to switch your table date time column [DateKey] to local time via copy and paste the code below , assuming the " 12" is hours , and "10"  is minutes ,which is the changed Time between the local timezone and UTC timezone.

     

     

     

    DateTimeZone.SwitchZone(DateTime.AddZone([DateKey], 0),-12 ,10)

     

     

     

     

    You can learn more: https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    You can use DateTimeZone.SwitchZone function to switch your table date time column [DateKey] to local time via copy and paste the code below , assuming the " 12" is hours , and "10"  is minutes ,which is the changed Time between the local timezone and UTC timezone.

     

     

     

    DateTimeZone.SwitchZone(DateTime.AddZone([DateKey], 0),-12 ,10)

     

     

     

     

    You can learn more: https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

    The incremental refresh partitions are based on UTC. Have a look at the partition sizes and compare those to your expected row count for the same periods.