Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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!
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.
Today and Today can be different things. The Power BI Service and the Sharepoints run on UTC. What is your timezone?