How do you store DateTimeTimezone without DATETIMEOFFSET?

[arpost]

Greetings, community. I am working to move some Gen 1 dataflows over and have the data stored in a Fabric data warehouse. The data has date/time values with user-specific timezone offsets listed (2024-02-07T09:15:00-07:00).

Given that Fabric DW doesn't have the DATETIMEOFFSET data type, I'm not sure what the best alternative approach is to handle different time zones. Anyone have suggestions?

[ameer_techsavy]

Hi @arpost Did you get an way to overcome Date Time OFFSET

[v-cboorla-msft]

Hi @arpost 

At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.
Appreciate your patience.

Thanks.

[v-cboorla-msft]

Hi @arpost 

Apologies for the inconvenience.

Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thank you.

[arpost]

@v-cboorla-msft, thanks for the reply. I thought I was instructed by some Microsoft support previously that MS Support is for technical support (e.g., there's a bug) as opposed to advisory help (e.g., how do I accomplish X in Fabric). Has that changed? I'm perfectly happy to send a ticket and get some advice on how to use Fabric for this use-case.

[v-cboorla-msft]

Hi @arpost 

Apologies for the delay in response from my end.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thank you.