Table visuals sharepoint list data

[bzeeblitz]

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

[v-sgandrathi · Accepted solution]

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!

[v-sgandrathi]

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.

[v-sgandrathi]

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.

[v-sgandrathi]

HI @bzeeblitz ,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[lbendlin]

Today and Today can be different things. The Power BI Service and the Sharepoints run on UTC.  What is your timezone?