Location of SQL Statement dialog on Azure Cosmos DB v2(beta) connector

[jfieck]

Hello all.  I did find the thread for "Azure Cosmos DB V2 Connector for Power BI - Missing Query option - Reg" which was addressing this issue but there was no clear resolution. 

Where is the SQL Statement (optional) window on Azure Cosmos DB v2(beta)

[jfieck]

What is odd is the Azure Cosmos DB v1 connector has the "SQL statement (optional)" dialog:

But the Azure Cosmos DB v2(beta) connector is not showing it:

The power query for v2 is CosmosDB.Contents .   I have been looking to see if I'm supposed to put something like query="select * from c" or something like that but have gotten over this yet.

The two articles referenced in the thread from the top didn't help much.  

Is the "SQL statement (optional)" window intentionally keep out of v2 by design?

[v-shex-msft]

Hi @jfieck,

Since this data connector still in public beta, so its optional parameter may not be similar as the GA version data connectors(azure cosmos v1 ). Perhaps you can try to contact to the dev team to get further support.

Power Query connector feedback - Power Query | Microsoft Learn

Regards,

Xiaoxin Sheng

[jfieck]

Thanks @v-shex I will ask the Power Query connector team...