Announcements
No record found.
We are using D365 F&O and I am trying to build out a powerbi report that can be used to review Project Timesheet hours before approving/posting so we can apply some criteria held in a workbook. The problem I am having is that the TSTimesheetLines table does not contain the hours per day. Which table has this data of hours per day?
Hi jvermette09,
The hours for timesheet entry are stored in the table TSTimesheetLineWeek. The field 'Hours' has 7 arrays; one for each day of the week.
Posted hour transactions can also be found in the table ProjEmplTrans.
Hi Andre,
Thanks for the response. However, I am not seeing that table in the available tables, all I see is TSTimesheetLines. Any ideas?
See the screenshot below. The table should be present.
I may have to revert back to my ISV on this one, for background I am on the Finance team so don't have the full technical skillset or access to the server explorer. I can tell you I am accessing via oData feed and do not have that as an available table.
You didn't mention that you were looking for details in data entities; I was assuming you were looking for tables.
The data entity you are looking at is having the Hours part of the design, but I'm also not able to see them using oData. They are working correctly within Dynamics 365 using Data management import and export.
I would suggest to log an incident for Microsoft Support.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 771
André Arnaud de Cal... 629 Super User 2026 Season 1
Subra 496
