Error when filtering odata query RRS feed

  • Question

  • Sorry - not sure if this fits in Power Query or Project category...

    I have both Project Online and Project Server instances of MS PWA. The Online instance has been around quite a while and I have been using the odata connections to create various reports using Power Query. When I try and replicate some of these reports for my Project Server instance I get an error message when trying to create filters for boolean fields.

    Example: I have a connection to ProjectData/Tasks and when I try and filter by TaskIsMilestone (built-in) or KeyTask (custom field = flag type) for 'true' I get:

    "DataFormat.Error: OData: The format 'application/atom+xml;charset=utf-8' is not supported.

    I've also written the query string (using regular Excel connections) in as many ways as I can think of but it's always the same problem.

    Any ideas?

    Monday, December 14, 2015 10:21 PM


  • Never mind... looks like this is a known bug but my error message was not the same as others had experienced. Guess I will have to recreate my KeyTask field as a text with look-up for Yes/No rather than a flag field.
    Monday, December 14, 2015 10:46 PM