Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
jfieck
Regular Visitor

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

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)

3 REPLIES 3
jfieck
Regular Visitor

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

jfieck_0-1713758231375.png

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

jfieck_1-1713758291806.png

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?

Anonymous
Not applicable

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

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.