Forum Discussion
Help with Power Query Date Table returning Error for some columns
I believe I have fixed the issue by having a play with the day offset filters and seems to be working as it should. Thanks for your time and help.
The URL doesn't work. It returns this:
I would not refer to any free website for a critical report.
If you want a dynamic date table that can handle timezones and doesn't rely on websites, try Creating a Dynamic Date Table in Power Query and Add a Refresh Time Stamp To Your Power BI Reports — ehansalytics which will walk you through the process and show you how to build a table to help with DST issues.
edhans thanks for the resources but I already have a working refresh timestamp on my report.
I also have a current date table in power query.
My issue I have is with relative date filters on my report when publishing to the service i.e. "in the last 7days", "in the last 1day (including today)", "is in this day" - it changes the dates to UTC. My timezone is NZST/NZDT which is UTC-12hrs
I've tried many suggestions on the forum and Google but can't seem to find one that works i.e. the relative date filters on my report don't display correct date based on my local timezone.
I've been at it for days and it's frustrating. Would appreciate your help please on how to resolve this issue.
Pbix file if you need
https://drive.google.com/file/d/1UwIN4N2y8EX4SdMbtfm87sCcWlIIaZ4L/view?usp=sharing