How do I get BI service to report in pacific time

[Jeff_Kunz]

I am importing data from a SQL server using query mode that has a day/time stamp in PDT. i need to be able to filter this data in pdt not UTC. any suggestions?

[Tad17 · Accepted solution]

This may be what you are looking for: https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337

Alternatively, you can add a column that adds the time zone to the date time that you have in the correct format and then add another column that recalculates the time in the desired time zone.