Copilot conversationtranscript content data in Power BI

[rondag24]

HI all - I want to be able to provide some data to copilot BOT owners about questions that users are asking and I can see that JSON in the content field in the conversationtranscript table in PowerBI. I have been able to use a series of steps in Power Query that are reasonably successful, but I was wondering if anyone else had something clean - I tried using the parse JSON function on the column but it doesn't show the record in the resulting data - just 'Record' and when I expand it, I don't see anything there either.

I am new to Power BI/Query so I would love some assistance.

Thanks!

Ronda

[Anonymous]

Hi @rondag24 ,

It sounds like you’re on the right track with using Power Query to parse JSON data in Power BI. 

Please check the structure of your JSON data. Ensure that it is well-formed and that the fields you are trying to expand exist in all records.
For more detailed guidance, you can refer to the

Parse text as JSON or XML - Power Query | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rondag24]

Thanks for your response Stephen - I did read that article, and the JSON is generated by Copilot itself, so I don't have any way to fomat or reformat.  The issue is that it generates a record, if I click on that record, there is a list within it and then another list within that and then about 15 or so records within those that actually have the data I want.  Since I am brand new to this with no assistance available within my organization, I guess I am just going to have to try to figure out how to get that 4 levels down data in my query.

Thanks again,

Ronda