Forum Discussion
Power BI refresh different time from Sharepoint
Hi,
I created a record in my sharepoint list this morning and the date was 2023/08/01. My sharepoint time zone is set as UTC+8:00
When I refreshed the data in Power BI, I found that the date was changed to 2023/07/31. And this resulted that I couldn't filter the data that created in 2023/08/01. I have checked my Power BI RS Desktop and its timezone has been set the same as sharepoint.
How can I fix this issue?
Very appreciate that if you can offer any help!
Hi , DylanHzj
Based on your issue description, I think this is caused by the timezone difference between the SharePoint list created date columns and the Power BI desktop displaying date timezone for the date values, this is a known limitation for the SharePoint list connector V1.0, mentioned in the official document, please kindly refer to this limitation description and work around provided mentioned in the official document:
Power Query SharePoint Online list connector - Power Query | Microsoft Learn
What's more, I think the more convenient solution is to switch the SharePoint list connector V2.0 beta version, it will be able to aviod more kinds of issues like the data difference based on the improvement from V1.0 connector:
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
3 Replies
- Idrissshatila
Super User
Hello DylanHzj ,
check if this solution is a help for your case https://community.fabric.microsoft.com/t5/Desktop/Power-BI-and-SharePoint/m-p/1690281
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thanks for replying, but it seems that the case you mentioned did not help.
- v-yueyunzh-msft
Community Support
Hi , DylanHzj
Based on your issue description, I think this is caused by the timezone difference between the SharePoint list created date columns and the Power BI desktop displaying date timezone for the date values, this is a known limitation for the SharePoint list connector V1.0, mentioned in the official document, please kindly refer to this limitation description and work around provided mentioned in the official document:
Power Query SharePoint Online list connector - Power Query | Microsoft Learn
What's more, I think the more convenient solution is to switch the SharePoint list connector V2.0 beta version, it will be able to aviod more kinds of issues like the data difference based on the improvement from V1.0 connector:
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
