DataSource Error in Connecting Azure Cosmos DB with Sql Statement

[Waseem_22]

Hello,

I am trying to connect to Azure Cosmos DB by writing a sql statement, but I am unable to fetch the data.

It says Datasource error (Screenclip attached).

I am able to get the data with URL and Database name, ,But when I entering Sql Statement it is giving an error. 

Can anyone please help me.

Regards,

Waseem

[amitchandak]

@Waseem_22 , with _ts it is giving an error. Can you check if that SQL is running directly on DB

[Waseem_22]

Thanks for replying @amitchandak , I have created a sampleDB provided by CosmosDB, which created a table with just 4 rows, I am trying to write SQL Statement based on that.

I am writing a sql statement as 
Select * From Persons where id = '61476e5d-ba88'.

Even with this I am getting the same error as