What is the Power BI Fund LInk?

Reuben Schmitz · August 4

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 · August 11

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 · August 6

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 · August 12

Thanks Alex.

What is the Power BI Fund LInk?

Best Answer

Answers

Categories