Import large number of data from Azure cosmos DB

[yyhk123]

Hi,
I am trying to import large number of data fromo Azure cosmos DB. However becuase it is so large, i am trying to limit the number by setting it to import only the past 90 days of data.

This is what i have done to import, input URL, input Database, Collection, and SQL statement as:
SELECT * FROM c WHERE c.metadata[0].modified_at < GetCurrentDateTime() and c.metadata[0].modified_at > DateTimeAdd("dd",-30,GetCurrentDateTime())

the date is stored in c.metadata[0].modified_at.

However the above query is not loading to the Power BI. Am I doing something wrong?
is there another way to bring only 90 days worth of data from azure cosmos db?

thanks!

[lbendlin]

Shouldn't CosmosDB be fast enough for Direct Query?

Alternatively, have you considered Incremental refresh?