Azure Cosmos Database and conversations chatbot

Manea, Daniela 20 Reputation points
2024-04-23T14:59:13.33+00:00

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

 

Azure OpenAI Service
Azure OpenAI Service
An Azure service that provides access to OpenAI’s GPT-3 models with enterprise capabilities.
2,266 questions
0 comments No comments
{count} votes

Accepted answer
  1. Dillon Silzer 54,746 Reputation points
    2024-04-23T15:37:57.8366667+00:00

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful