Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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...
User | Count |
---|---|
83 | |
77 | |
71 | |
69 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |