Extracting Project Online Timesheets Data to Excel using Odata is not accurate RRS feed

  • Question

  • Have anyone faced an issue extracting the Timesheets Data using Excel, I have records messed up and some missing records compared to the resources Timesheets ?

    Any other way to extract the Data ?

    Tuesday, December 5, 2017 2:45 PM

All replies

  • Hello,

    When you say extracting, is this just in to Excel or Power BI etc. or are you extracting the data from the ProjectData endpoint into a database etc.? Do you have specific examples for where this data is missing in the ProjectData endpoint? If so, you could open a support case on your Office 365 tenant so that it can be investigated.

    Paul Mather | Twitter | | CPS | MVP | Downloads

    Tuesday, December 5, 2017 2:59 PM
  • Hi,

    I was created an Excel report to consume Timesheet via oData only yesterday, and faced no issues in terms of data integrity.  The issue often is to understand the database structure, and to ensure that any data displayed (especially hours) is in the correct filter context etc if using DAX calcs.  Having said that, if you are using just Excel and bringing the data into the Data Model and haven't created any DAX expressions it should work okay.  The only thing you really have to do is create the relationships in the data model.  

    Ben Howard [MVP] | web | blog | book | P2O

    Wednesday, December 6, 2017 8:59 AM