Forum Discussion
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 "connectionreference" and here is the problem because I am get some weird JSON where when I am trying convert from string to JSON I recevied many new columns with probably some GUID.It is possible to received in other way the connection references , env variables and flows connected to canvas app ?
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.
4 Replies
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.