Some code to show how to add a timezone to the datetime2 in Fabric

datetime with timezone example.sql

-- Create test table
create table datetest (d varchar(50), dt DATETIME2(6));

insert into datetest SELECT 'Central European Standard Time', CONVERT(DATETIME2(6), '2022-03-27T01:01:00', 126)
AT TIME ZONE 'Central European Standard Time';

insert into datetest SELECT 'Pacific Standard Time' , CONVERT(DATETIME2(6), '2022-03-27T01:01:00', 126)
AT TIME ZONE 'Pacific Standard Time';

select d as TimeZone, dt as DateTime_without_TimeZone, 
		CONVERT(DATETIME2(6), dt , 126) AT TIME ZONE d as Datetime_with_TimeZone from datetest