It can be useful to export and visualize the data your conversational AI application generates in tools like Power BI.

In this How To we see how to connect the Analytics API to Azure Data Factory. We then see how to connect Azure Data Factory to Power BI. At a high level, the process in this How To consists of the following steps:

1. A manual invocation to fetch historical data from your conversational AI application
2. Subsequent automatic pulls to run periodically at a schedule of your choice
3. Data ingested, processed and stored into Azure Blob Storage for viewing in Power BI

The following sequence diagram depicts this process:

To implement this perform the following steps in sequential order:

1. Obtaining Your Application Id and API Key

2. Creating Resources In Azure Using The ARM Template

3. Adding Secrets To Azure Key Vault

4. Triggering The Initial Run In Azure Data Factory

5. Examining Azure Blob Storage Accounts

6. Connecting To Power BI