Azure Cosmos Database and conversations chatbot

Question

We have build a chatbot using Azure Open Ai and chatbot histories are saved in Azure Cosmos Data Base. How can we access these conversation and download them in a report or connect to Power BI ? What is the best way

 

Answer 1

Hi Daniela,

Please see the following tutorial:

Visualize Azure Cosmos DB data using Power BI

https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/powerbi-visualize

You can connect to Azure Cosmos DB from Power BI desktop by using one of these options:

• Use Azure Synapse Link to build Power BI reports with no performance or cost impact to your transactional workloads, and no ETL pipelines. You can either use DirectQuery or import mode. With DirectQuery, you can build dashboards/reports using live data from your Azure Cosmos DB accounts, without importing or copying the data into Power BI.
• Connect Power BI Desktop to Azure Cosmos DB account with the Azure Cosmos DB connector for Power BI. This option is only available in import mode and will consume RUs allocated for your transactional workloads.

If this is helpful please accept answer.