Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
bzeeblitz
Helper IV
Helper 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.                    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

 

 

 

1 ACCEPTED SOLUTION
v-sgandrathi
Community Support
Community Support

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!

 

 

 

View solution in original post

5 REPLIES 5
v-sgandrathi
Community Support
Community Support

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.

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
Super User
Super User

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

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.