I created 2 bots from the Copilot platform. One bot is created in a custom solution we created. Another bot is created in the default solution.
After creating the bot and testing it. I am able to see the analytics visuals and its corresponding data directly from the bot page as shown below. For both the bots, data in visuals are visible from the copilot studio site.
I am added to the "Bot Transcript Viewer security role", so I do have access to the table 'conversationtranscript'.
Now the issue, when I am connecting to the dataverse table via Power BI, I am seeing zero rows. To verify that this, I went to the table directly in the dataverse and there too I am not seeing any data rows. Just the columns. Screenshot for the same below:
Now the thing is, other tables like 'Copilot' and 'Copilot component' does have data and it shows the name, created date, modified date, etc. of the 2 bots that I have created. Only the transcript table is empty.
Please help me out here,
1. Why is there is no data in the conversation transcript table?
2. Where is the data in the 'Analytics' tab in the Copilot site actually coming from then? Is it a different location?
From all the various forums and blogs that I have read, everyone points to the conversation transcript table for the data. I did not find any alternative tables mentioned anywhere.