Dashboard showing different time zone ? How to change to correct time.

[DynamicsHS]

Hi, 

I have a dashboard which shows employee anniversaries. In our Dynamics 365 HR system I have someones anniversary as the 18th of May, but in my powerbi dashboard their anniversary date is coming up as the 17th. 

Why is powerBI doing this? is there a way to make sure the right anniversary time is coming up? 

Regards,

HS

[PC2790]

Hey @DynamicsHS ,

Is it showing incorrect in Power BI service or desktop?

You can try this:

In your powerBI desktop, go to File --> Options and Settings --> Options --> Crrent File--> regional Settings

Change the Locale for import to that of your own country. See if this fixes your issue.

Refer-Solving DAX Time Zone Issue in Power BI - RADACAD

Also see- DateTimeZone functions - PowerQuery M | Microsoft Docs

[DynamicsHS]

Thanks PC2790, 

I tried this but it didnt work unfortunatly.

[PC2790]

Where is it showing incorrectly?Desktop or service?

[DynamicsHS]

Desktop