Forum Discussion
bzeeblitz
Helper IV
1 year agoTable visuals sharepoint list data
I am not able to see the today's date items in table visuals from list1 sharepoint Data Source,I refreshed the dayasource in powerbi tables but no luck List1 //sharepoint list Date. ...
- 1 year ago
Hi bzeeblitz,
Thank you lbendlin for highlighting the timezone (UTC) impact that's a key point.
Additionally:
We should verify their timezone difference from UTC, check if the 'Date' field is properly detected as a Date type, confirm dataset refresh timing, and optionally create a calculated column to adjust to local time.visual filters should be checked carefully, especially when using relative date filters.
Hope this helps in resolving the missing records issue!
Thanks for reaching out! If this answer was helpful, please consider marking it as Accepted Solution and giving a Kudos, it helps the community!
lbendlin
Super User
1 year agoToday and Today can be different things. The Power BI Service and the Sharepoints run on UTC. What is your timezone?