https://community.fabric.microsoft.com/t5/Developer/Local-Time-Zone-Reporting-With-Azure-SQL-DirectQuery/m-p/809652#M21000 <P><SPAN>We have a web application in which we have embedded Power BI reports.</SPAN></P><P><BR /><SPAN>These embedded reports use the DirectQuery mode for connecting to AzureSql DataBase.</SPAN><BR /><BR /><SPAN>Our Database has DateTime values stored in UTC format. We want users to see these data values in their local time zone(i.e. if someone is in accessing reports from EST time zone they should be able to see reports in that zone and so on...)</SPAN><BR /><BR /><SPAN>Is there a way to achieve this?</SPAN><BR /><BR /><SPAN>Please help.</SPAN><BR /><BR /><SPAN>Thanks in advance</SPAN></P> Fri, 04 Oct 2019 06:07:20 GMT Anonymous 2019-10-04T06:07:20Z https://community.fabric.microsoft.com/t5/Developer/Local-Time-Zone-Reporting-With-Azure-SQL-DirectQuery/m-p/809652#M21000 <P><SPAN>We have a web application in which we have embedded Power BI reports.</SPAN></P><P><BR /><SPAN>These embedded reports use the DirectQuery mode for connecting to AzureSql DataBase.</SPAN><BR /><BR /><SPAN>Our Database has DateTime values stored in UTC format. We want users to see these data values in their local time zone(i.e. if someone is in accessing reports from EST time zone they should be able to see reports in that zone and so on...)</SPAN><BR /><BR /><SPAN>Is there a way to achieve this?</SPAN><BR /><BR /><SPAN>Please help.</SPAN><BR /><BR /><SPAN>Thanks in advance</SPAN></P> Fri, 04 Oct 2019 06:07:20 GMT https://community.fabric.microsoft.com/t5/Developer/Local-Time-Zone-Reporting-With-Azure-SQL-DirectQuery/m-p/809652#M21000 Anonymous 2019-10-04T06:07:20Z