Project Online ODATA Filter data from ResourceTimephasedDataSet

[waltercastillo]

I have a Project Online implementation, around 3000 resources, but not all have assignments, the ResourceTimephaseDataSet table is very big, because it create rows for all 3000 resources, then load this table is taking around 3 hours. Question: How can I filter the ResourceTimephaseDataSet table to just load rows based on the Resources that have assignments for a Power BI report?

[Anonymous]

Hi @waltercastillo ,

You can consider add conditions to url string based on URL Conventions, it should filter records before loading data to query table: URL Conventions (OData Version 3.0)

Regards,
Xiaoxin Sheng

[waltercastillo]

Thanks a lot Xiaoxin

I'm trying with Expand, but I don't find several samples with it.

I need more examples to understand how can I take this done.

WCC

[Anonymous]

HI @waltercastillo ,

Please refer to below odata basic filter tutorial from odata site:
Odata Basic Tutorial

Regards,

Xiaoxin Sheng