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

[Thiago_Melo]

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 type of refresh work, but i want to know if there's a way that i can still use incremental refresh with an API that uses this type of data? (i just cant't not use the timezone because when i dont't use i have problems with data)

[v-luwang-msft · Accepted solution]

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