Creating a Power BI report on the conversationtranscript entity in Cds
Has anyone had any success creating a Power BI report using the conversationtranscript entity as a source? Although I know it's possible to download the session data from within the PVA Analytics page, this is cumbersome to do and I'd rather set something up that can be run in the web service without relying on manual extraction of the csv files.
I've succeeded in connecting to the Cds entity and can transform some of the Json fields into columns, but there seems to be fields missing, such as Session Outcome. I'm trying to create some high level reports to be displayed in Teams for business users who won't be accessing the PVA interface. Anyone else looking at this?