Project Online - Enterprise Custom Fields and ProjectHasOverdueTasks

[kralco626]

This might be a limitation of the product, but I can't seem to get both of these pieces of information in the same dataset.

1) ProjectHasOverdueTasks (And several otherfields such as Tasks.TaskIsOverdue and Task.TasjIdOverdueAndUpcoming
This field is only available under Project when using BI Online to connect to Project Online using the built in service provider

2) Enterprise Custom Fields
These fields are only available if I use BI Desktop to connect to Project Online through OData.


I have read plenty of articles that say Enterprise Custom Fields are not available when creating the Dataset in BI Online, so I have chosen the BI Desktop route for my dataset so far. Is there a way I can get the ProjectHasOverdueTasks and similair fields in the BI Desktop OData connection method?

Thanks!

P.S. I know that technically I could find ways to calculate these fields... but really, thats a pain...

[v-yuezhe-msft]

@kralco626,

From this article, you can note that these fields(ProjectHasOverdueTasks, TaskIsOverdue and TasjIdOverdueAndUpcoming) are not in the list of available fields in Project OData feed, you would need to create these fields based on the existing fields and data.

Regards,
Lydia