Local Time Zone Reporting With Azure SQL DirectQuery

[Anonymous]

We have a web application in which we have embedded Power BI reports.

These embedded reports use the DirectQuery mode for connecting to AzureSql DataBase.

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...)

Is there a way to achieve this?

Please help.

Thanks in advance