Forum Discussion
power bi changes date from source data
Hi Anonymous,
I'm afraid your issue may caused by the timezone.
You could have a reference of this similar thread and try the workaround which meet your scenario.
If you still need help, I need more details about your scenario. Which connector do you use in Power BI when get data from SharePoint?
If it is convenient, please share some data sample which could reproduce your scenario so that I can have a test in my site.
Best Regards,
Cherry
There appears to be an issue with the time zone and daylight saving and SharePoint. When I use an excel file for the source data, the dates are correct, but not from SharePoint.
I have set up SharePoint with the correct regional settings, but Power BI amends the dates when importing them.
I have included some sample data to show the issue. It can be found here: https://www.dropbox.com/s/y75217g9al1mkoa/Example44.pbix?dl=0
For information the correct dates are shown in this table:
Title Initiative Name Start Date Original End Date Approved End Date Actual End Date C0005101 Project 1 29/01/2018 30/04/2018 31/07/2018 5/09/2018 C0008007 Project 2 15/02/2018 20/12/2018 20/12/2018 C0012001 Project 3 14/05/2018 31/07/2018 31/07/2018 C0021021 Project 4 1/03/2018 31/12/2018 31/12/2018 C0021022 Project 5 1/05/2018 28/02/2019 28/02/2019 C0021023 Project 6 1/06/2018 28/02/2019 28/02/2019 Thanks
Steve
Hi Anonymous,
By my tests with your data sample, I cannot reproduce your scenario.
I created the SharePoint List with your data sample and get data with SharePoint list connector in Power BI, everything works as expected.
Please check the timezone for your SharePoint and your Power BI.
Best Regards,
Cherry
Thanks Cherry
I have checked both SharePoint and Power BI settings and they are correct. So I am a bit stuck, without resort to a power query solution.
Cheers
Steve