UTC to PST on Direct query Azure DB

[Anonymous]

I know have searched a lot and ended up using many DAX on the direct query for converting UTC to PST and I keep getting below error message any help would be appreciated.

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

First of all, your connection mode is Direct query, so there are many limitations in Power query, and you need to switch to import mode.

Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn

So you could try it.

Get local date in Azure SQL database - AzureOps

If you change to import model. you could try it.

Handling Different Time Zones in Power BI / Power Query — The Power User

and if you use measure by dax .

Convert Time Zones in Power BI using DAX | NateChamberlain.com

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.