Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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:
|
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |