Forum Discussion
Project Online ODATA Filter data from ResourceTimephasedDataSet
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?
3 Replies
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 ShengThanks 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
HI waltercastillo ,
Please refer to below odata basic filter tutorial from odata site:
Odata Basic TutorialRegards,
Xiaoxin Sheng
