Forum Discussion
Solved
Power BI -> Dataverse Connection (Column connection reference in Canvas App)
Hello, I am trying to create a table where I will have each connection reference connected to related canvas app, I am on the part where I received a table canvasapp from dataverse with column "c...
Hi Yaybaa ,
Thank you for reaching out to Microsoft Fabric Community.
The JSON in connectionreference is expected – Dataverse stores it that way. Don’t parse it manually.
Instead, use the proper system tables:
connectionreferences > join with canvasapps to get friendly connector names.
environmentvariabledefinition / environmentvariablevalue > to list environment variables.
workflow (flows) + solutioncomponent > to see flows linked to the same app/solution.
This way you can map Canvas App > Connection References > Env Vars > Flows without breaking down JSON yourself.
