Forum Discussion
bzeeblitz
1 year agoHelper IV
Table 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
1 year agoSuper User
Today and Today can be different things. The Power BI Service and the Sharepoints run on UTC. What is your timezone?