Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
I have a data in Power BI and the source data is from Sharepoint list.
And I just discovered that some of the date in Power BI are different from Sharepoint where user register their item manually by creating a new item in sharepoint while some of it are correct.
For example:
Date data in Sharepoint: 28/9/2023 12:00:00
Date data in Power BI: 27/9/2023 12:00:00
I checked the region settings in sharepoint and I used UTC for it.
I already tried to change the timezone by changed it to local from the data type (UTC) and it's still not working, also tried this formula:
DateTimeZone.SwitchZone(DateTime.AddZone([Date], 0), 1)It's still not working.
And I can't use AddDays function because some of the date are correct. If I use the AddDate the correct one will be the incorrect one. Also I can't use add duration because the date different is exactly 1 day.
Is there any other solution for it? Your help will be so appreciated..
Thank you.
Solved! Go to Solution.
I usually add hours, then convert to date, but not sure if that's the "best" way (there's issues with daylight savings that way, but people usually aren't creating records at midnight so you don't tend to notice).
I usually add hours, then convert to date, but not sure if that's the "best" way (there's issues with daylight savings that way, but people usually aren't creating records at midnight so you don't tend to notice).
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 66 | |
| 46 | |
| 42 | |
| 26 | |
| 19 |
| User | Count |
|---|---|
| 193 | |
| 124 | |
| 101 | |
| 67 | |
| 49 |