SharePoint list incorrect data loading into PBI

I have a SharePoint list detailing exchange rates with a few columns. 

In the SharePoint list I have an 'EndDateofRate' as 30/06/2022 and a  'DateofRate' as 01/07/2022 but when I load the data into Power BI Desktop its showing 'EndDateofRate' as 29/06/2022 and 'DateofRate' as 30/06/2022

I haven't done any transformation this is just the initial load. 
I have checked the connection and the credentials are correct and can't seem to find any history of similar issues.

Power BI LoadSharepoint List