Forum Discussion
Copilot conversationtranscript content data in Power BI
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.
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