Project Online: Having problems filtering with strings in OData?

***4/26/2016 – You should no longer need to encode strings as our Cloud BI team have deployed some updates to resolve the issue of filtering with strings – if you don’t see it fixed yet tehn it should be very shortly.  Sorry for the inconvenience. *** *** 11/30/2015 – Quick update – again thanks Alex…


Project Online: OData–refreshing reports when changing languages

Thanks to Alex Silva for suggesting this posting – following hot on the heels of the reserved word post.  This relates to the differences seen when retrieving reports with OData in different languages.  In the previous post I showed how you could get different results by inserting the [LCID String] such as [pt-BR] to get…


Project Online: Demonstration package for OData and SSIS

Thanks Marc Boyer and Diane Diaz for the new document and demonstration package that shows how to do incremental downloads of assignment time phased data from Project Online Project Web Apps into a SQL Server database table.  This makes use of the SQL Server Integration Services (SSIS) OData feed that was introduced earlier in the…


Project Online: Updating OData connections in Excel for different PWA instances

Interesting question came in from one of our good partners, Campana and Schott, concerning the update of the connection string for Excel reports based on OData when moving the Excel books between different Project Online tenants.  This works just fine when just using the normal Excel features such as PivotTables – but you run into…