Forum Discussion

UKapadia's avatar
UKapadia
New Member
2 months ago
Solved

PowerBi vs. Amazon Redshift Different Minimum Report_Date from the same table After UTC Midnight

I'm encountering an issue with our Power BI dashboard related to data retrieval during the UTC time zone transition to midnight.   To provide some context, our dashboard pulls data for `current_dat...
Need Help
Show and Tell
Tips and Tricks
  • v-sshirivolu's avatar
    v-sshirivolu
    2 months ago

    Hi UKapadia ,

    Thank you for the update. Since adjusting the timezone logic did not resolve the issue and today's records are still missing after the UTC date transition, it would be helpful to review the exact query or filtering logic that is being used to return the current day plus the next three days.

    Could you also confirm whether the dataset is using Import mode or DirectQuery. Microsoft Learn documents that current date/time functions can be evaluated differently across environments, but additional query details would be needed to determine why the current day's records are being excluded in Power BI while they continue to appear in DBeaver.

    References:

    https://learn.microsoft.com/en-us/powerquery-m/datetime-localnow

    https://learn.microsoft.com/en-us/powerquery-m/m-local-fixed-utc-variants

v-sshirivolu's avatar
v-sshirivolu
Community Support
2 months ago

Hi UKapadia ,

Thank you for the update. Since adjusting the timezone logic did not resolve the issue and today's records are still missing after the UTC date transition, it would be helpful to review the exact query or filtering logic that is being used to return the current day plus the next three days.

Could you also confirm whether the dataset is using Import mode or DirectQuery. Microsoft Learn documents that current date/time functions can be evaluated differently across environments, but additional query details would be needed to determine why the current day's records are being excluded in Power BI while they continue to appear in DBeaver.

References:

https://learn.microsoft.com/en-us/powerquery-m/datetime-localnow

https://learn.microsoft.com/en-us/powerquery-m/m-local-fixed-utc-variants

v-sshirivolu's avatar
v-sshirivolu
Community Support
2 months ago

Hi UKapadia ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

 

  • v-sshirivolu's avatar
    v-sshirivolu
    Community Support
    2 months ago

    Hi UKapadia ,

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.