Hi I wonder if anyone has any examples or experience passing a ConstituentID from NXT to a PowerBI dashboard?
I've been following the instructions for passing the RecordID "context value" from a Constituent on this page:
Power BI add-ins - Microsoft Integrations
Per that doc, these are the additional parameters I've appended to the Add-in URL:
"&contextField=recordId&datasetName=FINALTARGET&datasetField=SYSID"
where "FINALTARGET" is the table in my model containing the constituent system record ID and "SYSID" is that ID.
The documentation doesn't explicitly say whether the field matching the recordID from NXT should be text or numeric only that "Most extension points provide context values as strings" so I've tested both string and numeric formats for "SYSID"
For testing, I've also been using a simplified version of my dash with just one table viz containing SYSID and constituent name columns. There are no filters being applied to that table in the dash.
So far, I can see my PowerBI dash in the Constituent dash tile and interact with it but it does not dynamically update/filter the tile to show the constituent whose page I am on.
Really appreciate any guidance or examples you may have.
Thanks!
