Date in PowerBI 1 Day Off From Data Source

[KDeRoo]

I work for a non-profit, and we've created some PBI dashboards to report on our donations received. There is something odd going on with the gift dates shown in the PBI dashboard compared to the gift dates in the database it's reading from. 

When I compare the data source (our actual databse) to the PBI dashboard side by side, the gift date is off by 1 day on all records. PBI is showing the gift date as one day later than the date in our database. This baffles me, since the dashboard is reading directly from our database. When I look at the data table view of my query in PBI Desktop, the date is off there already, so it's not in the visualization, but somewhere in how PBI reads the date from our database. 

The data type on the GiftDate field in our database is date (not date/time), and so is the data type of the GiftDate column in the PBI query. Super weird. 

Thoughts on how to fix this?

[KDeRoo]

Sorry it took me a while to get back here to respond... you were absolutely right, it had to do with the time conversion. Once I figured that out, everything matches up again.

Thanks!

[ChrisMendoza · Accepted solution]

@KDeRoo you mention database, do you mean like SQL Server etc.? It is likely that the database is recording in UTC and you need to convert the date & time to (even though you mention no time is recorded; it's 0:00:00). I do find it odd that you say "all records" though because depending on how far off of UTC you are I would imagine you'd see some that "line up".

In any case, try to convert the time in Power Query then loading that into your data model.