Power BI not retrieving project online timephased data
I have entered work against some tasks in Project Online. However when pulling the OData feed down in Power BI the AssignmentBaselineTimePhased datasets and AssignmentTimephasedDatsets are empty, despite not having any filters applied in Power BI.
The summary data in AssignmentBaselines is available but being summary values only plots as dots. How can the timephased detail data be retrieved?
The problem was actually that Microsoft have changed the default granularity of OData PWA feeds to "Never" for Timephased datasets. The purpose is to improve performance of the feeds by returning less data.
The fix is to change the reporting granularity in Project Online Reporting to (in this case) Daily:
Note: You'll have to republish your project for this to take effect.
MSDN blog post here: Project Online: Changes to Granularity of Time phased OData
- OData v4 multiple level $expand
- Modify response headers in SEGW Odata service
- Modify odata results after query
- InvalidOperationException: Can't use schemaId .. The same schemaId is already used for type
- How to pass ODataQueryOptions to Mediator while allowing input for OData queries only in Swagger?
- How can I filter via Get-MgAuditLogDirectoryAudit (through the Microsoft Entra Audit Logs) for a specific IP address?
- calling odata api on postman returns 406 Not Acceptable
- How to hide EF Context database schema via OData?
- is OData IQueryable async?
- The path template 'X' on the action 'X' in controller 'X' is not a valid OData path template. Resource not found for the segment 'X'
- OData query in swagger ui
- PowerBI Azure-Devops: query not showing links (as shown in Msft sample query)
- Restricting properties sent in a ODATA4 update
- How to find loading bottleneck of a slow-loading SAPUI5 app
- Accessing Azure DevOps Board custom field using OData query
- Formatter not called despite passing the same binding path
- ASP.NET Core 5.0 OData $select not working
- SAPUI5 OData V4 Read
- Odata Global PageSize
- ASP.NET WebAPI OData server side paging
- How to order the results by date?
- SAPUI5: FileUploader Not Working
- ASP.NET Core 8 Web API with OData
- ODataController erroring after return
- Paging in .NET Web API
- Odata override behaviour of orderby
- OData services with Elastic search
- How to best perform paging and sorting from multiple sources in JavaScript mashup
- OData client obsolete credentials property in version 8.x
- ASP.NET Core OData 8: allow deep navigation