Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Diff in dates source/power BI (time zone?)

Hi   I have power BI connected to Dynamics 365   The date I see In CRM is different form the date in power BI. It seems that power BI doesnt add GMT +1 even the regional settings is set to norway...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi

 

Thanks for answer

 

The column was alredy set to Date/Time/TimeZone

 

But the values displays the date and +00:00

Tahreem24's avatar
Tahreem24
Super User
6 years ago

Anonymous ,

 

Try to change your computer's timezone OR use the DateTime.AddZone function to achieve your expected output.

 

Dont forget to hit Thumbs up and also mark it as a solution if it helps you!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi thanks

     

    My computer i also set corrent to +1 gmt

    I want to make this change to all the columns in the dataset and the DateTime.AddZone I assume is only in one function?.

     

    Is this a bug in Power BI?