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.
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.
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
