Connect with me: ☕ Buy me a coffee: www.buymeacoffee.com/lisacrosbie 🦉 Learn more about AI: aka.ms/learnwithlisa 🖇 LinkedIn: www.linkedin.com/in/lisa-crosbie/ 📼 TikTok: www.tiktok.com/@lisa.crosbie 🐦 X (Twitter): twitter.com/LisaCrosbie 📚Take my LinkedIn Learning Course: Microsoft Power Platform Fundamentals (PL-900) Exam: Power Apps www.linkedin.com/learning/microsoft-power-platform-fundamentals-pl-900-cert-prep-power-apps/
This is one of the best Copilot Studio + OpenAI integration demos I've seen so far! Even better that what the official MSFT documentation has to offer. Thank you so much Lisa for putting this amazing content together.
This is great: a low-code RAG setup combining Azure OpenAI, AI/Cognitive Search, Sharepoint or Blob Storage. No more rolling your own by gluing together different vector databases, embedding models and large language models and hoping it all works.
Amazing video!! Thanks Lisa for sharing, it's so much easier to visualize how the integration happens rather than read through a bunch of docs! Thanks for the time you've taken!
Very informative, thank you for that video! The most thing that I learn from you, not only Copilot Studio and Azure AI Studio, but how to simplify sophisticated scenarios and use cases to link between business world and technical world, very appreciated.
Hey Lisa! Thanks a bunch for this, it's quite painful to go through all this with just documentation haha. Your videos have been super helpful and informative!
Thanks so for your videos. They are highly informative, short in explanation, not that boring as many many videos I have seen from Microsoft. Great job!
Hello Lisa, the video content is wonderful. I was looking for this solution, but it's hard to find even in English, let alone in Portuguese, my language. I work in a multi-family office with process management, and AI is breaking the paradigm. I've done some things with AI Builder, but there are certain limitations. Thank you very much for the content, and I would love to delve deeper. I'm building a model where employees will insert the descriptions of their processes via Power Apps in a structured way, and AI will unify it into a single content, being the brain of the company. From this point, we will have an unimaginable gain in business management, knowledge, and change... and much more. I'm very excited about all this. Thank you very much.
Thank you Lisa, your videos makes me learn things faster than going through documentation. And as you mentioned I'm interested in detailed videos on copilot studio with azure studio.
Super clear and concise! Just one question though, wouldn't be better to have a centralize place for a Copilot design? It's super confusing which tools are the right ones to develop a simple copilot: - Copilot studio - Open AI studio - Power apps - .. azure AI resources. I think it would be amazing to have a simple, centralized place for all AI experience. If you can make a video explaining each tool, that would be super helpful! Thank you!
Great and informative video. Just a note: I don't think the viewers care much about pre-recorded screenshots vs live demo as much as you do. For the viewers the information is important - not proving that it works in a live demo 🙂
Great video!!! what I want to know is when you ask an AI question, how do you know whether he is using his own connected Azure OpenAI model or a built-in model?
Hi, thanks for the great video! I've been testing Azure OpenAI on your Data, as well as 365 Copilot (mainly 365 Chat) and comparing the performance for the purpose of getting quick answers to information contained in PDFs (and other types of documents as well). 365 Copilot Chat does okay with general questions ("Summarize this document", "What are the main takeaways of this contract?"), but really struggles with more precise questions ("What is the agreed bonus on this contract?", "What are the special clauses pertaining to confidentiality in this document?"). FYI, I use it mainly with PDFs stored on a SharePoint team site. In comparison, Azure OpenAI on your Data is much better. It is able to answer with great precision on even the most specific questions. Why do you think that is? I was under the assumption that Microsoft would use the capabilities present in "Azure OpenAI on your Data" for their 365 Copilot. Do you think it might improve with time, until we actually get the same performance on both? Thanks !
Fantastic tutorial. I'm going to try implement copilot. I made a chat in the PVA, as you said, I had to build all topics manually in previous version. But now it seems so easy to create and more effective. Thank you for teaching.
Excellent Lisa! So, we can say that you connected a GTP-4 model to your copilot, right? in that case, if you ask something that is not in the data source, for example: "what is the number of countries in Asia ?" the chatbot will be able to answer that? I´m interesting in creating a chatbot in Copilot Studio that uses GPT-3.5 turbo model enhanced with some data, so if I ask the chatbot about the data it will give some references but if I ask the chatbot about a general question, like the example above, it will be able to answer that too
Hi Lisa. Thank you for this amazing instructional video. It is very helpful and well-prepared. I tested the model on various datasets and noticed that it struggles with analyzing raw data provided in a rigidly structured format (i.e., csv/xlsx/json). It usually limits itself to analyzing selected parts of the file instead of reviewing the entire dataset and returning results. Is there any way to force the model to calculate, for example, the sum of values in an entire column of a table located in a large file?
How can we test this. How to setup formal tests. How to evaluate the quality of a specific setup and choose the best solution quality/cost. Great video. Very inspiring
Thanks Lisa, very illustrative, can I integrate the new Copilot created from Powerapps or from a Web Application, or can I only use it from Copiloit Studio?
This video was very helpful, thank you for making it. Please, I have an OpenAI chat model linked to AI Search and deployed to Copilot just like you have in the video. However, the model didn't automatically add to the classic data in the Generative response, so I added it manually and set the connection properties. I didn't uncheck "Allow the AI to use its own general knowledge." My data source is Azure Data Lake Storage, not a direct source like you showed. Despite several tests, there's no response from my data source. Could you kindly advice? Thank you.
How do you create an index with multiple tables? The Azure Search Service only allows you to select a single table or view, but in your demo you have multiple tables in the index. How did you manage that? I would like to build something similar so that I can compare sales over years for our artists/products and compare sales to budgets, etc..
I'd love to know how you can connect or use an AI Assistant for Azure AI Studio from Copilot Studio, who is specialized on a certain task. E.g. Code generation.
@LisaCrosbie do we required the tenant license to integrate azure openai service . because i am not able to see the message when i am click on deploy to Microsoft copilot message "Welcome to Microsoft Copilot Studio name your bot to connect to your azure resource "
That's a great video, Lisa. However, can Microsoft Copilot Studio chatbot both use custom data for specific info like order tracking and be conversational (using an LLM or GPT)? For instance, offering choices like: "Your order is damaged. Would you prefer a refund or a replacement?
This was so informative, thank you Lisa. I'd love to see a video with Sharepoint as the data source, and perhaps using Power Automate and the Graph API to extract the data and push it forward into Generative Answers. I'm hoping that something like this would "get around" the two levels down search limitation for Sharepoint. Thoughts??
Thank you for the great tutorial. However, how to build a Copilot chatbot in Power BI that can answer questions based on the data we use in the Power BI report? Because the copilot currently available in Power BI can only answer simple questions and create simple summaries based on existing visualizations. Thanks in advance, Lisa!
How do I connect AzureOpenAI model with Copilot Studio via power apps - Connector option! I have connected the connector but I dont think its able to extract the AzureOpenAi model
Lisa, great video.. but where I get stuck is the "Deploy To" step. How come I'm only seeing "A New Web app" and no Copilot / PVA? Is it a licensing issue? I'm running on the Community Developer license as opposed to a paid license of Copilot Studio. My tenant also does not have a paid Copilot for M365 license. I wish Microsoft made these available for MVPs, but as it stands, the free Community license is what most of us are working with.
I’ve done this demo with only a Copilot Studio free trial. There is no dependency on a paid license or a Microsoft 365 license to do this. Go to copilotstudio.microsoft,com and sign in with your work account for a free trial and then try again.
Thank you for this insightful video! It's been just as helpful as your previous ones. However, I'm encountering an issue that I can't seem to pinpoint the source of. In Azure Open AI Studio, there are two possible ways to deploy your chatbot with your own data : through the web application or using the Copilot studio. Yet, I'm facing some confusion. It's my understanding that the Copilot studio utilizes a connection with Azure Open AI. So, why are the responses different between these two methods? The index that was created from the indexer that point to a blob starage with documents, deployment model, and all parameters remain consistent. What could be the reason behind these differing responses, or even worse, the lack of response to certain prompts?
Hi Lisa, thanks for the video. If I use a excel file or JSON or CSV file as my data in the method you mentioned, would copilot be able to do accurate calculations on the data. I'm asking this because, I uploaded my excel data as knowledge to copilot and its replies were all wrong when I asked it questions. Would Indexing the data and then passing it to copilot improve the results? Thanks for replying.
I’m wanting to essentially add a prompt to my Power App that lets me use Azure Open AI and ask questions about my data. Is this even possible in Power Apps?
Hey Lisa! I noticed that for you the connection was automatically made, when my copilot is created nothing is automatically made, do you know why this is the case?
At the moment it only works in a US environment and goes to the default environment. If you are outside the US, here's the workaround (which is what I used, I just didn't record it). powerusers.microsoft.com/t5/General/Azure-OpenAI-on-your-data-deploying-to-a-different-environment/m-p/2316247/thread-id/6412#M6413
Hey @@LisaCrosbie Thanks for the reply! I took a look at the article and it still does not work as expected in the france central env. It also specifically states: "as of now, only environments located in the US region can have that feature)" Did you also deploy your Copilot on an EU env or an US one?
Thank you for the great explanation. I have question here. I am working at a cloud billing position and hope i can use azureAI and copilot studio instantly for my tasks.(overview each subscription's monthly and annual cost / automatically make an esimate) Is it possible for now or impossible since it says it's only preview version?
Hey @LisaCrosbie. I am trying to implement it but I do not get Azure OpenAI option when I deploy my OpenAI model to Copilot Studio and add Conversational Boosting Topic. Would you please guide me? Thanks in advance
I have a content website that has multiple layers of subpages which have content on webpage. How do I ensure that the right subpage is picked based on the chat context. For example - country details with pages by country and based on the chat how can I ensure it determines the right country and accesses the right page?
May you know how can I speed up response calling Azure Open AI on Copilot Studio, I don't know why in the Chat Playground takes only a couple of seconds, and in Copilot's take more than 15s in average. I tried using HTTP Request node in Copilot Studio but is not getting as fast response as in the Open AI Studio . Is there a way to implement lazy loading content there?
It should work to add the same AI search to multiple bots. In each bot go into the Conversation Boost topic and edit the data source and select your Azure OpenAI deployment.
I have been engaged in a writing project with Chat GPT4o which stopped three days ago. Whenever I add new text, it disappears, which means my work, of over 700 pages, has come to an end. Do you have any idea how I might retrieve our missing work, on the same thread, so that we can continue?
Brilliant video. I'm getting my license to Copilot studio this week and I'm very excited to test it out. For this video, what other licenses did you need to achieve this? I thought I saw Visual Studio Enterprise on screen at one point. Thanks!
Yes, you need an Azure Subscription (mine is called Visual Studio Enterprise), and then you pay for whatever yo consume, the Azure AI Search resource here has varying prices depending on how complex your data and search needs to be. Then you pay for the usage of whatever model you deploy in OpenAI Studio.
If you have an existing Copilot studio chatbot...is it possible to connect to Azure OpenAI + your grounding data (located in Azure AI Search) from Copilot Studio rather than using the Deploy to CoPilot feature?
I figured it out.... you have to go to Connections in Power Apps in the same Environment as your Copilot and add the connection there. Then go to the Generative Answers topic and you will be able to select it. Then you can enter all the AI settings specific to your needs.
Hello, thanks for the video. I am currently working on a project and i am finding a big issue. I would like to know from your expertise to see if there is a possible solution. I have documents with sensitive data that i have to extract, however it seems that the new security features do not allow to extract names, dni, nif, etc. Some months ago this solution worked but now, not anymore. Do you know if there is any way to fix it? Thank you so much, i hope you or someone can help me.
Thank you very much for your efforts. Great videos. 🎉🎉🎉 Pity that there is no easy way to deploy from Azure AI Studio any more and really no documentation either on how to connect from copilot studio to azure ai models.
Hi Lisa, Great content as always!! For some reason I am unable to get the Connection to register in Copilot Studio after completing all the other steps. I know that it goes to Default and have seen ways to get past that (unsuccessfully though). Can you point me in a direction here, video or any other points I might be missing?
At the moment it only works in a US environment and goes to the default environment. If you are outside the US, here's the workaround (which is what I used, I just didn't record it). powerusers.microsoft.com/t5/General/Azure-OpenAI-on-your-data-deploying-to-a-different-environment/m-p/2316247/thread-id/6412#M6413
Hi thanks for the tutorial - it is really useful. somehow I am not able to add OpenAI connection in copilot - are you entering it manually (14.35 frame) ? there must be connection
At the moment it only works in a US environment and goes to the default environment. If you are outside the US, here's the workaround (which is what I used, I just didn't record it). powerusers.microsoft.com/t5/General/Azure-OpenAI-on-your-data-deploying-to-a-different-environment/m-p/2316247/thread-id/6412#M6413
I have a Shure M7 microphone, Elgato Facecam, one Elgato key light, Camtasia for recording and editing. The microphone and webcam are recent upgrades, I did everything for the first 3 years with a Logitech C920 webcam and blue yeti microphone. Nothing fancy.
Hi Lisa, thanks for the video. I tested it for myself and somehow the topic "conversational boosting" is not created automatically when i deploy it from Azure OpenAI Studio. Do you have any tips to get it working?
At the moment it only works in a US environment and goes to the default environment. If you are outside the US, here's the workaround (which is what I used, I just didn't record it). powerusers.microsoft.com/t5/General/Azure-OpenAI-on-your-data-deploying-to-a-different-environment/m-p/2316247/thread-id/6412#M6413
@@LisaCrosbie thanks for the link. yeah I'm outside the US. When clicking on the deploy to Copilot Studio button it is directing me to the correct environment and a connection is automatically created. Just the automatically created chatbot is not getting the "conversational boosting" topic automatically. I can enable the conversational boosting in the chatbot settings, then it gets created. In the create generative answer activity I can select the azure open connection, but it is not working. I always get an empty response back. Do you have any advice for that?
Thanks for the video, very helpful. However, after I publish to Copilto Studio from OpenAI portal, the OpenAI connection isn't appearing under the data sources. Additionally, when I attempt to add the connection manually, it displays "No connection to show." . Any idea what might be the reason?
Great video, Lisa. I am new to your content and really enjoyed the knowledge. Could you zoom in next time so that we can see what you are working on more clearly? You know, for us 40-year-olds, lol!
Hello Lisa, I tried to do the exaxt same steps as you did in te video, but the copilot doesnt work properly, the system topic about conversational bossting does not appeard and when i tried to do the topic manually the conecction doesnt work as is should, because all the details like the Deployment are in blank, could it be because im in Europe? thanks in advance
Yes, it is because you're in Europe. This only works on a US environment at the moment - here's the workaround for now. powerusers.microsoft.com/t5/General/Azure-OpenAI-on-your-data-deploying-to-a-different-environment/m-p/2316247/thread-id/6412#M6413
Power BI has its own natural language/Copilot experience, i'd be looking at that rather than trying to build it. Or else connect this (PVA) Copilot to the original data source underneath Power BI.
Check that in settings - Generative AI - you have generative answers switched on. If that doesn't solve it, I'd suggest posting in the Copilot studio community forum for help. powerusers.microsoft.com/t5/Copilot-Studio-Community/ct-p/PVACommunity
Thanks for sharing the valuable topic, I am definitely going to try the hands on it as I have the use case ready and was waiting for client approval :D
Found one issue in this. It seems having access to Azure OpenAI Studio is beyond the limits of most of us mere mortals. 🙂 Those of us not coming through an org or being an MVP/RD Will have to wait for it to become truly publicly available.
Just giving a heads up to anyone trying to follow this tutorial. Using the exact steps in the video the responses are very poor outside of the one shown in the video. Asking about different states and cities returns Hotels from wrong states, and none of the data outside of the descriptions are accessible by the model, making almost all the data in the table useless.
i created a bot to get data from power automate. Queries are processing but all of sudden i encountered with this error. Please guide me how to fix this. Sorry, something unexpected happened. We’re looking into it. Error code: SystemError. Conversation ID: a:1K5fPrGJJqIjyMmvY-ZJ5DwFM9_7gxpst3k72CXeZWcUQlPveUg2Qj_7dmise6JlX2_SYEkroO2XZUhX_cawdCEls6XLFu2NuBe-FDW_xKRxOoNXuc0R7F-Uvqpax5kmk. Time (UTC): 9/4/2024 6:05:40 AM.
Connect with me:
☕ Buy me a coffee: www.buymeacoffee.com/lisacrosbie
🦉 Learn more about AI: aka.ms/learnwithlisa
🖇 LinkedIn: www.linkedin.com/in/lisa-crosbie/
📼 TikTok: www.tiktok.com/@lisa.crosbie
🐦 X (Twitter): twitter.com/LisaCrosbie
📚Take my LinkedIn Learning Course: Microsoft Power Platform Fundamentals (PL-900) Exam: Power Apps www.linkedin.com/learning/microsoft-power-platform-fundamentals-pl-900-cert-prep-power-apps/
This is one of the best Copilot Studio + OpenAI integration demos I've seen so far! Even better that what the official MSFT documentation has to offer. Thank you so much Lisa for putting this amazing content together.
This is great: a low-code RAG setup combining Azure OpenAI, AI/Cognitive Search, Sharepoint or Blob Storage. No more rolling your own by gluing together different vector databases, embedding models and large language models and hoping it all works.
That tech is so 2023! 😆
Amazing video!! Thanks Lisa for sharing, it's so much easier to visualize how the integration happens rather than read through a bunch of docs! Thanks for the time you've taken!
Very informative, thank you for that video!
The most thing that I learn from you, not only Copilot Studio and Azure AI Studio, but how to simplify sophisticated scenarios and use cases to link between business world and technical world, very appreciated.
Thanks for the video. I am a dev myself and i'm trying to learn low code RAG stack. This is wonderful and helped me consolidate my ideas.
Hey Lisa! Thanks a bunch for this, it's quite painful to go through all this with just documentation haha. Your videos have been super helpful and informative!
Thanks so for your videos. They are highly informative, short in explanation, not that boring as many many videos I have seen from Microsoft. Great job!
Hello Lisa, the video content is wonderful. I was looking for this solution, but it's hard to find even in English, let alone in Portuguese, my language. I work in a multi-family office with process management, and AI is breaking the paradigm. I've done some things with AI Builder, but there are certain limitations. Thank you very much for the content, and I would love to delve deeper. I'm building a model where employees will insert the descriptions of their processes via Power Apps in a structured way, and AI will unify it into a single content, being the brain of the company. From this point, we will have an unimaginable gain in business management, knowledge, and change... and much more. I'm very excited about all this. Thank you very much.
Fantastic video thank you, waiting for the SPO one :)
Thank you Lisa, your videos makes me learn things faster than going through documentation. And as you mentioned I'm interested in detailed videos on copilot studio with azure studio.
Super clear and concise! Just one question though, wouldn't be better to have a centralize place for a Copilot design? It's super confusing which tools are the right ones to develop a simple copilot:
- Copilot studio
- Open AI studio
- Power apps
- .. azure AI resources.
I think it would be amazing to have a simple, centralized place for all AI experience. If you can make a video explaining each tool, that would be super helpful!
Thank you!
Great and informative video.
Just a note: I don't think the viewers care much about pre-recorded screenshots vs live demo as much as you do. For the viewers the information is important - not proving that it works in a live demo 🙂
Thanks 😊
Great video!!! what I want to know is when you ask an AI question, how do you know whether he is using his own connected Azure OpenAI model or a built-in model?
The room details are not showing up in the mapping field. Is it because its a complex type?
Hi, thanks for the great video!
I've been testing Azure OpenAI on your Data, as well as 365 Copilot (mainly 365 Chat) and comparing the performance for the purpose of getting quick answers to information contained in PDFs (and other types of documents as well).
365 Copilot Chat does okay with general questions ("Summarize this document", "What are the main takeaways of this contract?"), but really struggles with more precise questions ("What is the agreed bonus on this contract?", "What are the special clauses pertaining to confidentiality in this document?"). FYI, I use it mainly with PDFs stored on a SharePoint team site.
In comparison, Azure OpenAI on your Data is much better. It is able to answer with great precision on even the most specific questions.
Why do you think that is? I was under the assumption that Microsoft would use the capabilities present in "Azure OpenAI on your Data" for their 365 Copilot. Do you think it might improve with time, until we actually get the same performance on both?
Thanks !
Fantastic tutorial. I'm going to try implement copilot. I made a chat in the PVA, as you said, I had to build all topics manually in previous version. But now it seems so easy to create and more effective. Thank you for teaching.
Thank you for the video, Lisa! Is it fairly straightforward to then host this copilot on a Sharepoint site?
Hi Lisa, what did you use for the recording of this video, where you are in a little square and the recording looks nice. What app did you use?
Camtasia
Excellent Lisa! So, we can say that you connected a GTP-4 model to your copilot, right? in that case, if you ask something that is not in the data source, for example: "what is the number of countries in Asia ?" the chatbot will be able to answer that? I´m interesting in creating a chatbot in Copilot Studio that uses GPT-3.5 turbo model enhanced with some data, so if I ask the chatbot about the data it will give some references but if I ask the chatbot about a general question, like the example above, it will be able to answer that too
Hi Lisa. Thank you for this amazing instructional video. It is very helpful and well-prepared. I tested the model on various datasets and noticed that it struggles with analyzing raw data provided in a rigidly structured format (i.e., csv/xlsx/json). It usually limits itself to analyzing selected parts of the file instead of reviewing the entire dataset and returning results. Is there any way to force the model to calculate, for example, the sum of values in an entire column of a table located in a large file?
Hi Lisa, can we connect our azure open ai with the microsoft dataverse, when we talk about add your data in the azure chat ai ?
Very good Lisa! Yes more content please, especially around pdf uploads
Hi Lisa! Thanks for this guide :) May i know what subscription is needed to have access to both Copilot Studio and Azure Resources?
How can we test this. How to setup formal tests. How to evaluate the quality of a specific setup and choose the best solution quality/cost.
Great video. Very inspiring
Thank you. How can we publish it as rest API so we can connect it through own web not in copilot studio?
Thanks Lisa, very illustrative, can I integrate the new Copilot created from Powerapps or from a Web Application, or can I only use it from Copiloit Studio?
This video was very helpful, thank you for making it. Please, I have an OpenAI chat model linked to AI Search and deployed to Copilot just like you have in the video. However, the model didn't automatically add to the classic data in the Generative response, so I added it manually and set the connection properties. I didn't uncheck "Allow the AI to use its own general knowledge." My data source is Azure Data Lake Storage, not a direct source like you showed. Despite several tests, there's no response from my data source. Could you kindly advice?
Thank you.
is there any way to skip the OpenAI resource here? Could I directly connect an Azure AI Search resource with Copilot Studio?
How do you create an index with multiple tables? The Azure Search Service only allows you to select a single table or view, but in your demo you have multiple tables in the index. How did you manage that? I would like to build something similar so that I can compare sales over years for our artists/products and compare sales to budgets, etc..
I'd love to know how you can connect or use an AI Assistant for Azure AI Studio from Copilot Studio, who is specialized on a certain task. E.g. Code generation.
This was OUTSTANDING!!!! Going to connect with you!!!!
@LisaCrosbie do we required the tenant license to integrate azure openai service . because i am not able to see the message when i am click on deploy to Microsoft copilot message "Welcome to Microsoft Copilot Studio name your bot to connect to your azure resource "
That's a great video, Lisa. However, can Microsoft Copilot Studio chatbot both use custom data for specific info like order tracking and be conversational (using an LLM or GPT)? For instance, offering choices like: "Your order is damaged. Would you prefer a refund or a replacement?
This was so informative, thank you Lisa. I'd love to see a video with Sharepoint as the data source, and perhaps using Power Automate and the Graph API to extract the data and push it forward into Generative Answers. I'm hoping that something like this would "get around" the two levels down search limitation for Sharepoint. Thoughts??
Thank you for the great tutorial.
However, how to build a Copilot chatbot in Power BI that can answer questions based on the data we use in the Power BI report? Because the copilot currently available in Power BI can only answer simple questions and create simple summaries based on existing visualizations. Thanks in advance, Lisa!
How do I connect AzureOpenAI model with Copilot Studio via power apps - Connector option! I have connected the connector but I dont think its able to extract the AzureOpenAi model
Great demo @LisaCrosbie. My AI Studio only has a "Export to as Web App". Am I doing something wrong?
Hi Lisa, Do you have any information on the additional costs of the Azure Open AI integration to Copilot Studio?
Here's the pricing azure.microsoft.com/en-au/pricing/details/cognitive-services/openai-service/
Thanks @lisa! I need to get to learning Copilot Studio!! I'd love to learn what this fabric thing is too!!
Even though I'm a techie, I think you're the greatest and I like your videos. Keep up the good work and maybe do a video on semantic ranker :)
Lisa, great video.. but where I get stuck is the "Deploy To" step. How come I'm only seeing "A New Web app" and no Copilot / PVA? Is it a licensing issue? I'm running on the Community Developer license as opposed to a paid license of Copilot Studio. My tenant also does not have a paid Copilot for M365 license. I wish Microsoft made these available for MVPs, but as it stands, the free Community license is what most of us are working with.
I’ve done this demo with only a Copilot Studio free trial. There is no dependency on a paid license or a Microsoft 365 license to do this. Go to copilotstudio.microsoft,com and sign in with your work account for a free trial and then try again.
Thank you for this insightful video! It's been just as helpful as your previous ones. However, I'm encountering an issue that I can't seem to pinpoint the source of.
In Azure Open AI Studio, there are two possible ways to deploy your chatbot with your own data : through the web application or using the Copilot studio. Yet, I'm facing some confusion. It's my understanding that the Copilot studio utilizes a connection with Azure Open AI. So, why are the responses different between these two methods? The index that was created from the indexer that point to a blob starage with documents, deployment model, and all parameters remain consistent. What could be the reason behind these differing responses, or even worse, the lack of response to certain prompts?
Hi Lisa, thanks for the video. If I use a excel file or JSON or CSV file as my data in the method you mentioned, would copilot be able to do accurate calculations on the data. I'm asking this because, I uploaded my excel data as knowledge to copilot and its replies were all wrong when I asked it questions. Would Indexing the data and then passing it to copilot improve the results?
Thanks for replying.
I’m wanting to essentially add a prompt to my Power App that lets me use Azure Open AI and ask questions about my data. Is this even possible in Power Apps?
Hi Lisa. Does the data remain private? Thank you.
Great content. Learnt alot in 15 minutes!
Hey Lisa!
I noticed that for you the connection was automatically made, when my copilot is created nothing is automatically made, do you know why this is the case?
At the moment it only works in a US environment and goes to the default environment. If you are outside the US, here's the workaround (which is what I used, I just didn't record it). powerusers.microsoft.com/t5/General/Azure-OpenAI-on-your-data-deploying-to-a-different-environment/m-p/2316247/thread-id/6412#M6413
Hey @@LisaCrosbie
Thanks for the reply! I took a look at the article and it still does not work as expected in the france central env. It also specifically states: "as of now, only environments located in the US region can have that feature)"
Did you also deploy your Copilot on an EU env or an US one?
@@LisaCrosbie I'm also currently stuck there and looking to resolve the same, but unfortunately the link you shared is also not opening up :-(
Thank you for this! I'd love to see more on taking things to the next level!!
Thank you for the great explanation.
I have question here. I am working at a cloud billing position and hope i can use azureAI and copilot studio instantly for my tasks.(overview each subscription's monthly and annual cost / automatically make an esimate)
Is it possible for now or impossible since it says it's only preview version?
Hey @LisaCrosbie. I am trying to implement it but I do not get Azure OpenAI option when I deploy my OpenAI model to Copilot Studio and add Conversational Boosting Topic. Would you please guide me? Thanks in advance
I have a content website that has multiple layers of subpages which have content on webpage. How do I ensure that the right subpage is picked based on the chat context. For example - country details with pages by country and based on the chat how can I ensure it determines the right country and accesses the right page?
what is the significance of Azure bot service now ? when and how it can be used in conjunction with copilot studio ?
Hi it was Great video loved it. Does the create generative answer return only maximum of 3 references.
May you know how can I speed up response calling Azure Open AI on Copilot Studio, I don't know why in the Chat Playground takes only a couple of seconds, and in Copilot's take more than 15s in average. I tried using HTTP Request node in Copilot Studio but is not getting as fast response as in the Open AI Studio . Is there a way to implement lazy loading content there?
Great video. Is it possible to connect to a data model that is in Fabric?
Does this work with relational database ?
How I can integrate on prem. Confluence site with copilot studio chat bot? Is there any easy solution?
This video describes a game changer! Thank you!
Nice 😊
Can we use the Azure AI search for multiple bots or one AI search per bot?
It should work to add the same AI search to multiple bots. In each bot go into the Conversation Boost topic and edit the data source and select your Azure OpenAI deployment.
I have been engaged in a writing project with Chat GPT4o which stopped three days ago. Whenever I add new text, it disappears, which means my work, of over 700 pages, has come to an end. Do you have any idea how I might retrieve our missing work, on the same thread, so that we can continue?
Thank you Lisa!! Fantastic video and exactly what I have been looking for
I keep getting the "I’m sorry, I’m not sure how to help with that. Can you try rephrasing?" answer. Any idea why?
Brilliant video. I'm getting my license to Copilot studio this week and I'm very excited to test it out. For this video, what other licenses did you need to achieve this? I thought I saw Visual Studio Enterprise on screen at one point. Thanks!
No other Power Platform licenses, but you would need Azure credits or pay for Azure consumption against the Azure resources you deployed.
Yes, you need an Azure Subscription (mine is called Visual Studio Enterprise), and then you pay for whatever yo consume, the Azure AI Search resource here has varying prices depending on how complex your data and search needs to be. Then you pay for the usage of whatever model you deploy in OpenAI Studio.
What is the pricing like?? Any realistic numbers given a scenario where u use it the whole month?
If you have an existing Copilot studio chatbot...is it possible to connect to Azure OpenAI + your grounding data (located in Azure AI Search) from Copilot Studio rather than using the Deploy to CoPilot feature?
I figured it out.... you have to go to Connections in Power Apps in the same Environment as your Copilot and add the connection there. Then go to the Generative Answers topic and you will be able to select it. Then you can enter all the AI settings specific to your needs.
Hello, thanks for the video. I am currently working on a project and i am finding a big issue. I would like to know from your expertise to see if there is a possible solution. I have documents with sensitive data that i have to extract, however it seems that the new security features do not allow to extract names, dni, nif, etc. Some months ago this solution worked but now, not anymore. Do you know if there is any way to fix it?
Thank you so much, i hope you or someone can help me.
Hi Lisa, Can you work video also for SharePoint source only and please focus on API permission . especially Sites. Selected Permissions.
Nice and chill explaination.
Great video and it can be used in many organization. Thanks for sharing.
Thank you very much for your efforts. Great videos. 🎉🎉🎉
Pity that there is no easy way to deploy from Azure AI Studio any more and really no documentation either on how to connect from copilot studio to azure ai models.
thank you very much, very clear and easy information
Hi Lisa,
Great content as always!!
For some reason I am unable to get the Connection to register in Copilot Studio after completing all the other steps. I know that it goes to Default and have seen ways to get past that (unsuccessfully though).
Can you point me in a direction here, video or any other points I might be missing?
BTW, I am unable to create a new Azure Open AI Connection in Power Plat
At the moment it only works in a US environment and goes to the default environment. If you are outside the US, here's the workaround (which is what I used, I just didn't record it). powerusers.microsoft.com/t5/General/Azure-OpenAI-on-your-data-deploying-to-a-different-environment/m-p/2316247/thread-id/6412#M6413
Hi thanks for the tutorial - it is really useful. somehow I am not able to add OpenAI connection in copilot - are you entering it manually (14.35 frame) ? there must be connection
At the moment it only works in a US environment and goes to the default environment. If you are outside the US, here's the workaround (which is what I used, I just didn't record it). powerusers.microsoft.com/t5/General/Azure-OpenAI-on-your-data-deploying-to-a-different-environment/m-p/2316247/thread-id/6412#M6413
Would be great to see a video where multiple copilots created in this form can work cooperatively.
Lisa, what tool(s) do you use to make your videos?
I have a Shure M7 microphone, Elgato Facecam, one Elgato key light, Camtasia for recording and editing. The microphone and webcam are recent upgrades, I did everything for the first 3 years with a Logitech C920 webcam and blue yeti microphone. Nothing fancy.
@@LisaCrosbie Excellent. Thank you. Seems Camtasia has come a long way since the last time I looked at it. Well done.
Hi Lisa, thanks for the video. I tested it for myself and somehow the topic "conversational boosting" is not created automatically when i deploy it from Azure OpenAI Studio. Do you have any tips to get it working?
At the moment it only works in a US environment and goes to the default environment. If you are outside the US, here's the workaround (which is what I used, I just didn't record it). powerusers.microsoft.com/t5/General/Azure-OpenAI-on-your-data-deploying-to-a-different-environment/m-p/2316247/thread-id/6412#M6413
@@LisaCrosbie thanks for the link. yeah I'm outside the US. When clicking on the deploy to Copilot Studio button it is directing me to the correct environment and a connection is automatically created. Just the automatically created chatbot is not getting the "conversational boosting" topic automatically. I can enable the conversational boosting in the chatbot settings, then it gets created. In the create generative answer activity I can select the azure open connection, but it is not working. I always get an empty response back. Do you have any advice for that?
@@blacktergumI'm also facing the same issue. Did you figure that out?
Kindly provide a video for sharepoint online as datasource please
It’s on my (very long!) list, thanks for upvoting it ☺️
@@LisaCrosbie Cant wait to see that video. Thanks
Thanks for the video, very helpful. However, after I publish to Copilto Studio from OpenAI portal, the OpenAI connection isn't appearing under the data sources. Additionally, when I attempt to add the connection manually, it displays "No connection to show." . Any idea what might be the reason?
I also have a similar problem. I can see the connection and select it but it doesn't fill the other fields automatically. Have you found a solution?
Same problem too@@pooneh1894
@@pooneh1894 No, I can't even find the connection in the first place :/
Great video, Lisa. I am new to your content and really enjoyed the knowledge. Could you zoom in next time so that we can see what you are working on more clearly? You know, for us 40-year-olds, lol!
Oh, i feel that pain too - noted for future, thanks.
Hello Lisa, I tried to do the exaxt same steps as you did in te video, but the copilot doesnt work properly, the system topic about conversational bossting does not appeard and when i tried to do the topic manually the conecction doesnt work as is should, because all the details like the Deployment are in blank, could it be because im in Europe? thanks in advance
Yes, it is because you're in Europe. This only works on a US environment at the moment - here's the workaround for now. powerusers.microsoft.com/t5/General/Azure-OpenAI-on-your-data-deploying-to-a-different-environment/m-p/2316247/thread-id/6412#M6413
@@LisaCrosbie does this integration between Copilot Studio and Azure Open AI works in Europe now?
it would be great to see an implementation with data from PowerBI or Where the PVA uses Flow as a skill to complete an action
Getting data from Power BI would require AI to be good at writing DAX (unless you’re pre-baking all the queries). Maybe we will get there soon. 😅
Power BI has its own natural language/Copilot experience, i'd be looking at that rather than trying to build it. Or else connect this (PVA) Copilot to the original data source underneath Power BI.
Would you please export conversational boosting topic as it is no longer available for me in my Environment
Check that in settings - Generative AI - you have generative answers switched on. If that doesn't solve it, I'd suggest posting in the Copilot studio community forum for help. powerusers.microsoft.com/t5/Copilot-Studio-Community/ct-p/PVACommunity
Fantastic video; it would be amazing if you could do a video using Sharepoint as your data source.
Working on it! Thanks.
we need to integrate the questions and answers to be voice to your created system workflow
i want to make copilot studio make learn how is it possible
Good demo
Thanks for sharing the valuable topic, I am definitely going to try the hands on it as I have the use case ready and was waiting for client approval :D
Awesome, good luck!
Awesome!
Found one issue in this. It seems having access to Azure OpenAI Studio is beyond the limits of most of us mere mortals. 🙂 Those of us not coming through an org or being an MVP/RD Will have to wait for it to become truly publicly available.
At this stage yes, you do have to apply for access if you have a use case.
I got into the preview. Not sure how that happened. :-)
Just giving a heads up to anyone trying to follow this tutorial. Using the exact steps in the video the responses are very poor outside of the one shown in the video. Asking about different states and cities returns Hotels from wrong states, and none of the data outside of the descriptions are accessible by the model, making almost all the data in the table useless.
Can you give me the exact questions you’re using and I’ll give it a try.
„No more darkmode, I’m afraid“ 😎
seems that is not valid any more, do you have any updated video could share?
Which part isn’t valid?
i created a bot to get data from power automate. Queries are processing but all of sudden i encountered with this error. Please guide me how to fix this.
Sorry, something unexpected happened. We’re looking into it. Error code: SystemError. Conversation ID: a:1K5fPrGJJqIjyMmvY-ZJ5DwFM9_7gxpst3k72CXeZWcUQlPveUg2Qj_7dmise6JlX2_SYEkroO2XZUhX_cawdCEls6XLFu2NuBe-FDW_xKRxOoNXuc0R7F-Uvqpax5kmk. Time (UTC): 9/4/2024 6:05:40 AM.
Awesome !