Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
We have a time registration report based on the OData feed to project online.
We extract the timesheetLines and use this to aggregate the required data. Unfortunately there are thousands of records in this table, and the extract runs quite slow.
We only need data for the last couple of months, but the table holds date for almost two years.
Is there any way to limit the extract to only pull current month + the last two months? I know I can filter this in the reports, but I want to get the data out already at the extraction point.
Regards
Michael
Solved! Go to Solution.
@fiilen,
You can add $filter parameter into your OData URL. For more details, please review the examples in the blog below.
https://pwmather.wordpress.com/tag/excel/
https://project-brain.com/2016/07/24/odata-reports-with-project-onlineproject-server-part2/
A detailed list about filter command is listed in this article.
Regards,
Lydia
@fiilen,
You can add $filter parameter into your OData URL. For more details, please review the examples in the blog below.
https://pwmather.wordpress.com/tag/excel/
https://project-brain.com/2016/07/24/odata-reports-with-project-onlineproject-server-part2/
A detailed list about filter command is listed in this article.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.