power bi changes date from source data

[Anonymous]

When I get data from SharePoint, or refresh the data, Power BI changes the dates that are downloaded from SharePoint.

For instance I have a column called "Period Start" which is always the first day of the month, and a column called "Period End", which is always the last day of the month. Power BI changes the Period Start from the first day of the month to the last day of the previous month (eg from 1 Oct 2018 to 30 Sept 2018), and changes the Period End from the last day of the month to the second last day of the month (eg from 31 Oct 2018 to 30 Oct 2018).

It does this for other date columns as well. The date shown in the table is the day before the date in the original data source.

Why does it do this? And can I prevent it from happening?

Steve

[v-piga-msft]

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

[Anonymous]

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

[v-piga-msft]

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

[Anonymous]

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

[gpiero]

@Anonymous

at the beginnig of my experience with Power BI I had the same issues with a Sharepoint custom list.

Please try to check if the post below could helpyou

Regards

https://community.powerbi.com/t5/Desktop/Wrong-input-in-a-field-Date/m-p/215986#M95632