Description: This post addresses two topics
- Display a report's refresh date and time converted from UTC to local time, including support for U.S. Daylight Saving Time and time-zone abbreviations.
- Demonstrate how a Power BI report template (.pbit) can provide a reusable foundation for building consistent, professional-looking reports across your organization.
- Required connections: None, all sample queries are created with M Code
- Suggested skill level: Beginner
- Configuration details: Open the .pbit and adjust to fit your theme or follow the instructions to build from a blank report.
- Category: Power Query, Report sample
- Instructions: PDF included in the .zip download
Alternatives:
Alex Wong shared a web service that also provides a requested timezone's date and time, accounting for DST wherever you are: Power BI Refresh Date/Time - Blackbaud Community. It looks like this service is no longer active, but maybe there is another option out there.
The attached template includes a basic, reusable date dimension. If you are looking for a method to dynamically identify the start and end of your date range based on another query's results, check out:
Sharing my Power BI template: Calendar Query aka Date Table - Blackbaud Community
