Azure OpenAI Service
An Azure service that provides access to OpenAI’s GPT-3 models with enterprise capabilities.
Database collection not selectable when using Azure Cosmos DB for MongoDB vCore as a data source in AI studio
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 10%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGL%3C/text%3E%3C/svg%3E)
Gustavsson Ludwig (SEIT)
0
Reputation points
I am trying to use Azure AI Studio/Azure OpenAI with Azure Cosmos DB for MongoDB vCore as a data source but when I get to the Select Database step I get stuck as Database collection is not selectable. I have tried with multiple browsers on different machines but I can never select the Database collection. When I tried this a couple of weeks ago it was working with the exact same database and I have not changed anything. And yes I do have a database collection and index inside my mongodb and tried on a newly created one aswell. So is this some kind of bug or am I missing something?
Azure OpenAI Service
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 24%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
navba-MSFT 27,620 Reputation points Microsoft Employee Moderator2024-10-15T10:02:27.8533333+00:00 @Gustavsson Ludwig (SEIT) Welcome to Microsoft Q&A Forum, Thank you for posting your query here!
.
Plan 1:
For using
Azure Cosmos DB for MongoDBwithin Azure OpenAI there are a fewpre-requisitesandlimitations. Ensure that you have followed this:Prerequisites
- vCore-based Azure Cosmos DB for MongoDB account
- A deployed embedding model
Limitations
- Only vCore-based Azure Cosmos DB for MongoDB is supported.
- The search type is limited to Integrated Vector Database in Azure Cosmos DB for MongoDB with an Azure OpenAI embedding model.
- This implementation works best on unstructured and spatial data.
Data preparation
Use the script provided on GitHub to prepare your data.
More info here.
.
.
Plan 2:
To use Azure Cosmos DB, you must configure the role assignments from the user to the Azure OpenAI resource. Required role:
Cognitive Services OpenAI User..
Plan 3:
Please confirm if the Cosmos DB doesn't have any private endpoint and VNET/Firewall configured and it is publicly accessible as shown below:
.
Plan 4:
Please click on the F12 button and open the Browser developer console and try to check within the console tab for any errors which selecting the collection?
.
.
Plan 5:
Please collect the browser HAR traces and share it from the Private message in .txt format.
.
Awaiting your reply.
-
navba-MSFT 27,620 Reputation points Microsoft Employee Moderator
2024-10-16T10:33:36.4233333+00:00 @Gustavsson Ludwig (SEIT) Just following up to check if my suggestion helped. Please let me know if you had any updates on this.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 77%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY9%3C/text%3E%3C/svg%3E)
YutongTie-9091 54,021 Reputation points Moderator2024-10-17T23:35:02.0333333+00:00 Hello @Gustavsson Ludwig (SEIT) We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Regards,
Yutong
Sign in to comment
Sign in to answer