Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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)
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?
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...
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
70 | |
57 | |
37 | |
36 |
User | Count |
---|---|
85 | |
65 | |
60 | |
46 | |
45 |