Forum Discussion
Direct Query date conversion from UTC to Local Timezone
Anonymous , when you create a connection there is the connection to give a query. You can use that.
simple addition and subtraction can work in dax and power query. If your timezone do not change with the season then you can simply try to add and subtract time and check
Anonymous ,the best way is to use a SQL in advance option and do the conversion in SQL.
Is there a way to do it in Power BI? The reason is I am not the owner of the SQL DB and any changes to it might be a long process of approvals and documentation.
Anonymous , when you create a connection there is the connection to give a query. You can use that.
simple addition and subtraction can work in dax and power query. If your timezone do not change with the season then you can simply try to add and subtract time and check
Yeah, that worked brilliantly, thanks for the quick response 🙂