Forum Discussion
Filtered query to Cosmos DB for large data set
Hello, I am storing a large IoT data set in a Cosmos DB collection. At the moment I am using Power BI to exploit and display the information stored in this collection. The more the collection...
Hello Yuliana,
I found an mid-way solution using parameters. I defined "initDate" and "finishDate" as text-type parameters.
Then I modified the query so it looks like:
= DocumentDB.Contents("https://{comos-db-name}.documents.azure.com:443/", "{db-name}", "{collection-name}", [Query = "SELECT * FROM Document WHERE Document.date BETWEEN '"&initDate&"' AND '"&finishDate&"'"])
However, I am still wondering if it can be done playing with dates built-in functions.
I want to know that, but also if there is a way that instead of using Text parameters as you mention, use GETDATE(),