Forum Discussion
UTC to PST on Direct query Azure DB
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.
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.
1 Reply
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.