none
Can I query a Microsoft Project file using Power Query? RRS feed

  • Question

  • I'd like to query project titles and attributes from a Microsoft Project file posted on a file share or SharePoint site.
    Wednesday, March 25, 2015 3:01 PM

Answers

  • The only OData feed I'm aware of for Project is for Project Online and would not apply to a simple MPP file hosted in SharePoint. Export to CSV or XML is probably your best bet.
    Wednesday, March 25, 2015 6:05 PM

All replies

  • It looks like the MPP format is undocumented and there are no components available for reading it -- so this would not be possible for us.
    Wednesday, March 25, 2015 3:22 PM
  • Thanks for getting back to me on this.  Would you suggest exporting the mpp file to a CSV format perhaps?  Also, does OData feed apply in this case or is that just for Office files, specifically Office 365 files?  Thanks again.
    Wednesday, March 25, 2015 4:27 PM
  • The only OData feed I'm aware of for Project is for Project Online and would not apply to a simple MPP file hosted in SharePoint. Export to CSV or XML is probably your best bet.
    Wednesday, March 25, 2015 6:05 PM