Forum Discussion
Date 1 day behind source date
Cul33 - Smells like a timezone problem but hard to say. I suppose you either need to track down the discrepency in the date/time setting. Dublin is +1 UTC so that's almost assuredly where your issue is coming into play. The time is some date at 12 AM, you subtract an hour and it is the previous day.
So, your options are probably to track down the source of who is assuming UTC (probably Power Query/Power BI) and make it see reason, or you could fix it with a calculated column. In Power Query that would be:
Date.AddDays([Column1],1)In DAX:
[Column1]+1
Cul33 I found your post as I had the same issue. The only way I found a way to get the dates to match from sharepoint to powerbi came down to something so simple I can't believe it. When you get data, choose 'More' then 'Online Services' then 'Sharepoint Online List' (I know you could select Sharepoint list in a quicker way than this), add your sharepoint list url and CHANGE implementation from 1.0 to 2.0 THIS is the vital step I found to solve my woes! Hope it helps anyone else, I'll sleep easy knowing this is working...at least for me!
