[ChatGPT + Enterprise data] with Azure OpenAI and Cognitive Search - Part 3 with SharePoint Library
HTML-код
- Опубликовано: 24 июл 2024
- 🚀 In this video, we dive into the latest feature of using the ChatGPT Playground with your own data in Azure OpenAI. Explore it on Microsoft's website:
learn.microsoft.com/en-us/azu...
🌐 Essentially, you can swiftly deploy the same web app we created in the first video, but this time, it's linked with SharePoint Document Libraries. 🚀 Watch Part 1
🏗️ Our journey starts with creating a SharePoint indexer, adding it as a data source in the Chat Playground, and deploying the web app. No need to run the code; Azure OpenAI Studio handles that for you.
🌟 While it may not be flawless in data ingestion, it's still an amazing app that's incredibly user-friendly.
⏱️ Here's what's in store:
0:00 - 🎬 Opening
0:34 - 🚀 Create Azure OpenAI Service
2:27 - 💬 Try Azure OpenAI Studio Chat Playground
5:24 - 📝 Overview of SharePoint Indexer for Azure Cognitive Search
7:08 - 🔍 Create Cognitive Search Service
10:24 - 🔐 App Registration
13:50 - 📚 SharePoint Document Library Preparation
14:29 - 📦 Create Data Source
18:58 - 🔍 Create Index
20:02 - 🕵️ Create Indexer
24:00 - 📂 Managing Supported File Formats
26:58 - 🔄 How to Update the Data Source
29:23 - 🚀 Deploy the Web App
34:15 - 📊 Azure Cognitive Search Index Limitation
36:20 - 🚀 Possible Future Improvement
38:18 - 🎉 Wrap Up
🗨️ Don't forget to leave a comment if you got it working! We're here to help and learn as well. 😊
🔗 Watch part 1: • [ChatGPT + Enterprise ...
🔗 Watch part 2: • [ChatGPT + Enterprise ...
Thanks for this vedio Brother.....it very useful and helpful for me... thanks a ton
is that your indexer still catch 1 document after you try to add one more PDF document of Appl? Maybe that's why result on web app not shown because the indexer that connect data source with a target search index
Hey man, became a dedicated subscriber of your channel here, every video teaches me exactly what I need!
Have you got any examples of adding complex column types from Sharepoint library to indexer? As an example, Term Store (Taxonomy) multi-select columns?
Oh thanks bro, I am so flattered. No I don't, I am also a learner. Will need to work on my SP Indexer more, hoping with Hybrid Search technique.
Not able to create indexer on my end. Getting no error messages just sending request stuck on postman
Do you have any video showing the parameter that needs to be passed in the http connector when you leverage Azure OpenAI that is linked to Azure AI Search with an index in Power Virutal Agent via PowerAutomate call?
Note that MS have reported a known issue with delegated permissions. To create the indexer use app-based permissions instead.
what is the reason you cannot change pricing tier? was there any limitations in doing so?
Great videos you are making. Have you figured out how to enable vector search for the SharePoint index? The "Add vector search to this search resource" option is disabled when adding a data source for Cognitive search in the Azure OpenAI Chat playground. For Blob data source the same options is enabled and you can select an embedding method like ADA.
Is it deployed in regions that support it?
Hi man!! Thanks for sharing all this videos.
I wanted to know, if it's possible to apply filters in the DataSource or in the indexer. I mean, to only bring documents with an specific value in a SharePoint Column? Thanks again.
Thanks for the kind words! In my video, I am filtering the file formats. I am not sure what other type of filtering it supports.
Thank you bro for the video, on ChatGPT + Enterprise data with Azure OpenAI and Cognitive Search - Part 3 with SharePoint Library how can i customize the UI instead of using standard Microsoft one ?
Bro you need to go to MS Github repo and modify their code. I am no expert creating UI so you have to share once you did it.
Hey mate, on POSTMAN, i got ERROR 401, is it because there is not link between my postman account & my azure account ?
The POST API link is the right one, i've looked at it, also is there any requirement for the sharepoint access ? (open to everyone?) ? In my console i can see : Knockkknockk in error.
Hey I don't think it is account related. You are posting to a public endpoint when you created the ACS and index.
Hi I want to take only a specific folder as data source. Can I do that or can we only use the root URL as data source?
You mean a specific folder in SPO library? I believe so.
Getting the error "The given API key is not permitted in the URI query string." return when doing the postman call. Followed the instructions word for word, any idea how to get around the error?
Sorry Michael, I need to check back on this. It’s been so long that the API call might have changed!
can we add pre built skill set for the data source we created using SharePoint indexer.
I think so. Let me know how you did it.
can we customize web app UI after deployment? I want to replace Azure logo to my selves
let me know if you figured this out, looking to do the same thing
Thanks for this great posting! .... I am trying to adapt it for a multi-tenant solution as I am trying to use my MSDN Visual Studio tenant as the indexer, and my company's tenant as the SharePoint site. When I go to create the indexer it comes back with an error saying that Application was not found in my company's tenant .... which is true ... I created it in my MSDN tenant. Should I try creating an App Registration in my company tenant and then enter that App ID into the datasource of the ACS on my MSDN tenant?
actually ... I just realized that creating the app ID on my company tenant isn't exactly what we want to do either, because the chat playground is on my MSDN tenant and wont have acces to it when I want to hook up my sharepoint index into it. ... hummm .... somehow it seems like I have to be able to create a app ID on my company's AD that points back to the App Regigration in my MSDN account and acts like a proxy ...
Or maybe I have to recreate the App Registration in my MSDN account as a multi-tenant registration ....
So ... I switched the application registration in my MSDN account to Multi-tenant and that seemed to do the trick! I can now index documents on my company's sharepoint site .... I also needed to provide the tenant ID in the connection string, which I obtained through our sharepoint administrator
Hey buddy, it looks like MS ACS supports multi-tenants but looked complex. I am so glad you did it! Why don't you make a video to share with the world! It will benefit business that have subsidiaries through MA activities and kept multiple Azure tenants.
Hi, How can you connect Azure OpenAI to SharePoint? What settings do you apply to SharePoint so that Azure can access the data source? Please kindly your advice, thank you
You need to create ACS Indexer for SharePoint and use Azure OpenAI Studio to build it, as described in the video.
Is there any permission setting on the SharePoint side to enable Azure to access SharePoint data? I failed while creating the ACS indexer. @@gptOdyssey
Hi, Any idea why my indexers request does not finish after using the code to login on browser?
When it finishes after a long time I get this message: "Error with data source: AADSTS70020: The provided value for the input parameter 'device_code' is not valid"
Let me know if you got his fixed
Also getting this Error. No indexer is created. Tried creating it using the gui in Azure, but then nothing happens. Anyone found a solution for this?
it was working but suddenly unable to run indexer, create new indexer. giving transit failure, though authenticating after the get call it gives another code. any idea why sir?
I need more context but check out this blog with detailed step ty step guide, it might help! www.linkedin.com/pulse/chatgpt-enterprise-data-azure-openai-cognitive-search-leo-wang-1c
Hello ,thank you for your reply. With your video i was able to perform all actions sucessfully. As said It was working perfectly fine. When I added a new file to share point I had to run the indexer, then the get call to authenticate. I give the code and sucessfully authenticate. But indexer post will be still running and to check status if run the get call I get another code and same gets repeated
Hey Im running in a issue where I have full site control but "Error with data source: Code: accessDenied
Message: Access denied
Inner error:
\tAdditionalData:
\tdate: 2023-08-24T22:59:38
\trequest-id: ..... Please adjust your data source definition in order to proceed."
is the response when creating indexer
please link your blog
Please follow this blog: www.linkedin.com/pulse/chatgpt-enterprise-data-azure-openai-cognitive-search-leo-wang-1c
Hi Brother...while creating indexer , get method it is not showing error msg for me ... hence post method indexer is keep on sending the request...can you please help me.
So does the Get Indexer command return anything at all?
@@gptOdyssey thanks for reply... there was little mistake in get method I gave index name instead of indexer name....now it got sorted... thanks once again for the vedio it helped me lot ...
it is just giving the url of the service so from where do we search the code@@gptOdyssey
I have the same issue brother
@@vinodreddy2535 please check the link which you used in postman I mean the post request cause I got it corrected