Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help with Power Query Date Table returning Error for some columns

Hi, I have this script for a date table but the "Offset" columns are returning error. The script was sourced from Radcad site  and the only change I made to the script was input my 'api key' and cha...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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

      • v-kkf-msft's avatar
        v-kkf-msft
        Community Support
        4 years ago

        Hi Anonymous ，

         

        Relative date filtering in Power BI Service defaults to UTC time zone, and we cannot change the time zone at this time.

         

        This script does not allow us to use the relative date filters correctly, rather it creates several Offset Date slicers to achieve the same result as the relative date slicers. That is, you need to use [Day Offset] for filtering.

         

         

        If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
        Best Regards,
        Winniz
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.