Not getting expected asset report through google ads api.

Hello!

I am trying get asset data through the api.
On the google ads website I can create the report, so I know for sure the data is there.
But when I try through the api, then I just get an empty result.
When I enable tracing there is no information about any errors in the log.

This is the query I am trying:

SELECT asset.final_urls, asset.id, asset.name, asset.resource_name, asset.source, asset.type, segments.date, metrics.conversions, metrics.cost_micros, metrics.ctr, metrics.impressions, metrics.clicks, metrics.cost_per_conversion FROM campaign_asset WHERE segments.date >= '2024-09-01' AND segments.date <= '2024-10-31'

Any ideas as to what happens?

Thank you in advance,
Anders

I have also checked that it isnt a permission issue (although i would expect that to be in the tracelog if it was due to missing permissions)