Power BI -> Dataverse Connection (Column connection reference in Canvas App)

[Yaybaa]

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 ?

[v-venuppu]

Hi @Yaybaa ,

I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.

Thank you.

[v-venuppu]

Hi @Yaybaa ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-venuppu]

Hi @Yaybaa ,

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[v-venuppu · Accepted solution]

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.