Power Platform Community Forum Thread Details

Hi All,

Sorry about the noise. I am new in the Copilot Studio Bot. However, I am going to be actively promoting Copilot Studio within our company. I hope you can share some of your experience or help me answer some of my questions. Thanks.

I am still choosing the type of database technology used for my Copilot Studio Bot.

1. Dataverse:

- provide the quickest go-to-market, not sure about the storage cost.

2. Azure Cosmos DB and wrap it with an Azure Function App API or a proper Web API.

- can have future benefits with potential out-of-the-box integration with Cognitive Search as a vector DB

Here are my questions:

1. How does the Dataverse connection be authenticated from the Copilot Studio bot? Is it a "client" side connection or "server" side? Is it direct call from the bot or via PowerAutomate intermediary? I cannot find any documentation on this - maybe Microsoft can help add documentation around security of how bot talks to the backend Dataverse and PowerAutomate.

2. What is the best practice to call external API? Directly from the bot or via PowerAutomate? what are the pros and cons of both options.

Thank you.

Categories:

General topics