RENXT Report Access through Power Automate to PBI

Kate Clayton · July 14

Hello all!

We use a RENXT Report to show an upcoming pledge schedule for a particular fund, and I would like to include this in a PowerBI dashboard we are using to cover that funds activity.

The other information in this dashboard comes from RENXT lists and queries, which we have been able access via Power Automate no problem, but for some reason I can't find where the Report Execution Job is, but I know it definitely exists and I should have the correct permissions as they are the same as the RENXT Query Connector, as outlined here https://learn.microsoft.com/en-us/connectors/blackbaudrenxtreport/ (I have a PowerAutomate Premium License)

Our Blackbaud rep consulted with their Innovation Product Manager who says that Microsoft may have shortened the name of the connector, but I have looked through all of the ones I can see and none of them mention anything about reports? They have indicated that I should ask here next, in case anyone has more information on where I can find it.

Apologies if this is a silly question, but I have mainly called RENXT/FENXT queries in PowerAutomate, and there is no one at my org who is able to provide greater insight to where I might find the ‘Start a report execution job’ connector.

Thanks!

Erik Leaver · July 15

@Kate Clayton Hi Kate, I was able to find the “Blackbaud RENXT Reports” connector inside Power Automate, + New connection.

b11c437356e1c72148b16f33071916bc-huge-im

I then created an instant cloud flow, and called up “Start a report execution job”:

83103ed81026748172eb3023bb3c71b3-huge-im

You likely need to add this connection so you can access the Start a report execution job.

Kate Clayton · July 15

@Erik Leaver
Hey Eric, Thanks for this description. Myself and my PA Admin have both looked there and Reports is not in the list of connectors shown, see below.

a24606535bba44f0708155aeca2ee71d-huge-sc

Erik Leaver · July 15

@Kate Clayton Are you Searching for “Blackbaud Raisers Edge…” or "Blackbaud RENXT"? Our newer connectors all start with "Blackbaud RENXT"

Kate Clayton · July 15

@Erik Leaver I've tried both, here's the only two I see under Blackbaud RENXT

0419c41298b371eaf6194696e04ff6c4-huge-sc

Alex Wong · July 15

@Kate Clayton
from where you are flow > connections > new connections, you may only see connectors that you previously used.

Go to editing of flow, and then click on new action, search for “blackbaud reports”, mouse over the one at the top row, it should say Blackbaud RENXT Reports.

242e18d097414f85be4d85af2ee6731a-huge-im

Kate Clayton · July 16

Hey @Alex Wong,

I tried there first, I see all the rest that you see but Reports is not in that list

ce02a9eb343881c42320d489704e1f8e-huge-im

Alex Wong · July 16

@Kate Clayton
where are you located?

The reason for this question is, when Blackbaud certify it's connectors with Microsoft, the rollout is not to all “regions” at the same time. I don't know when Blackbaud rolled out the Blackbaud Reports connector, so maybe there is a delay to your location.

@Erik Leaver would have more info I think.

You can also use the Blackbaud Add-in connector to issue HTTP request directly for API, though it is a little “harder” to use, but this requires no wait time if it was a MS/BB issue.

Kate Clayton · July 16

@Alex Wong
I'm in Canada (Ontario), I feel like I saw Reports in the list a few weeks ago but haven't seen it since.

I'll give the HTTP request a shot, thanks for the advice

Erik Leaver · July 16

@Alex Wong US is the largest region & goes last. So if we have the certified connector, everyone should have it.

@Kate Clayton can you create a brand new cloud flow, and add just the one action?

If that fails, I'd like you to test in the Standard Reports API reference “Try it” as well. That should verify you have access to the Standard Reports API.

4676f4448f448a18b53f01ac729bce05-huge-im

If that fails, it might also be worth testing against the SKY Developer Cohort as everyone should have access there.

Kate Clayton · July 16

@Erik Leaver

Adding just the one action to a brand new flow didn't allow it to show up.

I went to the Standard Reports API reference and clicked to ‘try it’, and received this below?

bd74a0a8664ea0a70ff1652aae972380-huge-im

Erik Leaver · July 16

@Kate Clayton Recapping our troubleshooting today:

* You successfully connected to the Try It & executed the Reports API (not reflected in the above screenshot but I know you executed the call!). This confirms your organization has access to the Standard Report APIs.
* I tested with a user in Canada & they were able to locate the connector
* You were able to start an import a test flow with an action using the connection but were still unable to find the connector on the list of available connectors.
* You couldn't access a Power Automate trial environment for us to test if the issue is related to your specific Power Automate environment.

I'll check with some colleagues to see if they have any other ideas but this one is odd.

RENXT Report Access through Power Automate to PBI

Comments

Categories