Forum Discussion
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. Itemnumber
3/18/2025. 100
3/17/2025. 200
Table visuals powerbi //powerbi table visuals
Date. Itemnumber
3/17/2025. 200
I'm unable to find the 3/18/2025 Item in the powerbi table visuals,though I refreshed powerbi datasources but no luck
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!
5 Replies
Today and Today can be different things. The Power BI Service and the Sharepoints run on UTC. What is your timezone?
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!
Hi bzeeblitz,
I wanted to check in your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply as Accepted solution and give Kudos that helped you. It would be greatly appreciated by others in the community who may have the same question.
Thank you.
Hi bzeeblitz ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.
