DirectQuery not working because of certain transformations?

Hi, I am having a problem with a newly created report. In our company we already query data from Harvest through their API endpoint. There it is mostly about projects (500-2000 items). => https://hel...