Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 (+1 GMT)
from CRM:
27.okt.1998 00:00:00 (GMT+1
from Power BI:
Is this a time zone issue and how can I change this?
Here is my regional Settings - set to Norway - so it seems this is correct:
From the other posts on the forum the fix is in dax, but we have many datefields and want to fix this for the entire dataset and not just in one column
Thanks for any help!
Hi @Anonymous ,
Give a try by using Query editor --> Select your date column --> right click on it and select Change Type then choose Date/Time/TimeZone.
Please hit Thumbs up for support and also accept this as a solution if it helps you!
Hi
Thanks for answer
The column was alredy set to Date/Time/TimeZone
But the values displays the date and +00:00
@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!
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?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
61 | |
56 | |
55 | |
36 | |
34 |
User | Count |
---|---|
77 | |
73 | |
45 | |
45 | |
43 |