What is the Power BI Fund LInk?

Reuben Schmitz

In Power BI, I can connect donors, gifts and Actions to a power BI report using a formula. Is there a similar formula to link to a specific Fund in a Fund report?

I.e., the formula for donors is: CONCATENATE("https://host.nxt.blackbaud.com/constituent/records/",'Constituent(all)'[constituent_id] ) - i create this as a new Calculated column and then link it using Conditional Formatting on the data field in the report

any one have a similar formula for a Fund link?

Alex Wong

Here's the DAX from a BB custom Power BI connector Fund table.

Fund Link = CONCATENATE("https://host.nxt.blackbaud.com/cfa/funds/", Fund[fund_id])

Carol Grant

I don't know the exact way to use it in Power BI but I do know I can link to a Fund in an email using this path.

https://host.nxt.blackbaud.com/cfa/funds/[FundID]

Or I have a flow that uses this in the email that has the link to the fund.
<a href=https://host.nxt.blackbaud.com/cfa/funds/@{outputs('Get_a_fund')?['body/id']}>@{outputs('Get_a_fund')?['body/lookup_id']}</a>",

Reuben Schmitz

Thanks Alex.