Forum Discussion
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 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)
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 RegardsLucien
1 Reply
- v-luwang-msft
Community Support
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 RegardsLucien