Converting UTC to local Time Zone in Power BI

Power Query
2

Hi @matthew.wright,

You will find details on how to deal with that here in this topic.
Adding a Last Refresh date to your Report - #9 by Melissa

I hope this is helpful
Let me know if you have any questions