Forum Discussion

Thiago_Melo's avatar
Thiago_Melo
Frequent Visitor
4 years ago
Solved

Making incremental refresh with an date/hour/timezone type of data

Hi!   Recently i've been trying to create a incremental refresh for my dashboard, but the type of data is date/hour/timezone and apparently it should be only date/hour for this type to make this ty...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    Hi Thiago_Melo ,

    Referring to the official documentation, it seems to me that incremental refreshes are not supporteddate/hour/timezone type of data.

    You could try to 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)

     

     

     

    And refer :

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

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Thiago_Melo ,

Referring to the official documentation, it seems to me that incremental refreshes are not supporteddate/hour/timezone type of data.

You could try to 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)

 

 

 

And refer :

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

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien