Using Power BI to extract from MS Project Online RRS feed

  • Question

  • Within MS Project I can define my resources (people and teams) and assign them to a calendar.  I can also set up what their working week looks like, in terms of days and what hours they work.  However I've been unable to find this level of detail when I try to extract the data for reports in Power BI.  I have found the Resources and ResourceTimephasedDataSet tables and can extract the Capacity data but cannot see how that links to days of the week.

    I did see one post at "https community dot tableau dot com/thread/117458" explaining how to convert the FiscalPeriodId field into a date, using Dateadd however when I followed it the year value (I presume) was not in a format I recognise.

    Am I missing something obvious ?

    Is there, somewhere, a list of all MS Project tables and fields, just to ensure I've picked everything up ?

    Thanks, in advance, for any help that can be offered

    Friday, July 12, 2019 9:01 AM