PowerBI - Participant URL

Mark Palfrey

Hi there

I have created a PowerBI report and I would like to create a URL that when clicked on takes you straight to the constituents participants record. I have done something similar successfully with linking directly to the full constituent record by creating a column in Power Query and basically concatenating https://host.nxt.blackbaud.com/constituent/records/ with the System record ID. I tried doing the same with:

Combining that with the system record ID of the participation record but when that URL is clicked on that takes me to one of those “Heads up! You're in a restricted area.” pages. Any help would be really great.

Many thanks

Mark

Glen Hutson

@Mark Palfrey,

Try also appending the “envid=” and “svcid=” to that participant URL. I think that part of the system is a bit more particular about having those included as well. If you haven't worked with those pieces yet, the “svcid” is typically “renxt” and “envid” is specific to your environment. For example: https://host.nxt.blackbaud.com/participant/records/26959?envid=p-83a2mak-RLfHab32Ck9rCx&svcid=renxt (the envid in this URL is a made up one, so it won't actually take you anywhere).

Mark Palfrey

@Glen Hutson that totally solved the issue! Thank you for that bit of advice. All working great now in my PBI report.