PowerBI issues

Pippi Reader
Pippi Reader
Seventh Anniversary Kudos 1 Name Dropper Facilitator 1
in SKY Developer General Discussions

Hello

I was hoping to get your help. I have four PowerBI reports that are linked to RE via a JSON and it refreshes each night. It uses a Power Automate flow that refreshes this using BB Query API Data.

It has always worked fine but in the last few days it just stopped working. I get this kind of message from Microsoft and when you click on the link explaining the error it says this: 

{"error":{"code":"NoResponse","message":"The server did not receive a response from an upstream server. Request tracking id '08584307902361306542973682702CU10'."}}

An error occurred while processing the data in the semantic model.

Refresh failed:

Fundraiser Matrix has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

I have tried refreshing multiple times since then to refresh but it always fails

When I look in Power Automate the Query API says that it has Succeeded (see image):

image.png

but you can see from when I log into Power BI, all four semantic models have failed see image).

image.png

When I click into the error I receive from Power Automate, when you get to the Scope Full Process - you can see an action has failed (see image)

image.png

and then I click into this I see the error (see image)

image.png

I also found this message which I'm not sure if is helpful:

{"id":"52f8eedd-2f7a-4ba5-ae6f-b4fbe496615d","status":" Throttled","message":"Your request is being delayed because you have too many queries running right now. Your request will run once other queries have completed. You will receive a notification when this request has completed."}

I haven't changed anything in my reports but when I speak with Raisers Edge, they tell me it's nothing to do with them and the issue is with my report. The only thing I did change earlier in the week is that some of my Constituent IDs contained letters and that was causing an issue but i went into RE to change that so that they were all numeric. This then stopped the issue and I was able to refresh so I don't think it is anything to do with that.

Can anyone help? I'm at lost of what to do! @Alex Wong I know you have been super helpful in the past so just wondering if you might know what the issue is.

Answers

  • Ashley Moose
    Ashley Moose Blackbaud Employee
    Eighth Anniversary Kudos 5 First Reply Name Dropper
    edited February 11

    Hi @Pippi Reader - There was a breaking change to secure the Query endpoints that is causing this issue.

    Change Log - Raiser's Edge NXT - SKY API

    Take a look at the comments from Austen Brown from yesterday on this post for an explanation of how to fix - Sharing my Power Automate Flow(s): Get Query Results as JSON — Blackbaud Community.

  • Pippi Reader
    Pippi Reader
    Seventh Anniversary Kudos 1 Name Dropper Facilitator 1

    You are amazing - thank you! I've spent hours trying to figure out what is going on!!

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Ashley Moose thank you for sending the change log. However, this type of breaking change, I think the community of SKY API user will appreciate a "headsup" rather than, everything-broke-now-stumble-to-fix situation.

    @Pippi Reader it looks like you are using the Power Automate to provide Power BI data template I published, if so, I made an update to the post at the top that provided specific instruction to fix.

    image.png
  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Erik Leaver @Crystal Bruce tagging you 2 as well regarding my comment on breaking change

  • Pippi Reader
    Pippi Reader
    Seventh Anniversary Kudos 1 Name Dropper Facilitator 1

    @Alex Wong Thank you!

    I'm so new to Power Automate so worried I am going to break something, can I check should I be doing the following (sorry about my bad writing on the image)!

    So should I be deleting the json fx here as per the image

    image.png

    Then in the step above adding the Body here instead:

    image.png

    If so which body am I adding?

    Sorry it's probably really obvious!

    Thank you!

  • James Belich
    James Belich
    Kudos 1 First Anniversary Name Dropper Facilitator 1

    Hi @Pippi Reader , in your first image for the "Response JSON Data" action - yes, you want to delete the expression in the body field that starts with "json(…". This Action should come after an action that starts with HTTP (I think this is what your second image is of). You're not going to change the HTTP action (so in the second image with "Add here?" - the answer is no). Instead, in the "Response JSON Data" action where you deleted the "json" expression, you're going to add dynamic content that is the body of the HTTP action right before it. So, for example, my HTTP action is named "HTTP Get Query Results" - in the dynamic content menu, I'll see a section labeled "HTTP Get Query Results" with Body underneath. That Body is what will go into the body field of the "Response JSON Data" action. I hope that makes sense!

  • Pippi Reader
    Pippi Reader
    Seventh Anniversary Kudos 1 Name Dropper Facilitator 1

    Hi @James Belich Thank you! I'm sorry I'm still a bit confused but it's me not your explanation. So pasted below is the full image of what I'm seeing as it is currently set.

    So on Response JSON Data I remove the json but I'm not sure what I'm supposed to replace it with because I don't have anything in the Bodyf field for HTTP Get Query Results? Or am I misunderstanding.

    Sorry and thank you so much. It's all making me realise how little I know about Power Automate and how much of a problem this is when things go wrong! :)

    image.png
  • James Belich
    James Belich
    Kudos 1 First Anniversary Name Dropper Facilitator 1

    @Pippi Reader I completely understand! I'm still relatively new to Power Automate as well and it's taken me a little while to get my head around these things. 😄

    You're not going to need to make any changes to the "HTTP Get Query Request" action. Under "Response JSON Data," yes, you'll remove what's currently in the body field. Then, in this same field, add Dynamic Content. You should see something that looks like this:

    image.png

    Select Body in this section.

    Your "Response JSON Data" should now look like this:

    image.png

    Save the flow and you should be good to go!

  • Pippi Reader
    Pippi Reader
    Seventh Anniversary Kudos 1 Name Dropper Facilitator 1

    Thank you so much! I've got it! I've just clicked save and refreshed my semantic model so fingers crossed. THANK YOU!

  • Pippi Reader
    Pippi Reader
    Seventh Anniversary Kudos 1 Name Dropper Facilitator 1

    @James Belich it worked!! You have just made my day! thank you so much!

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    Yes, remove the json(…) from Response JSON Data

    do not make any change to the HTTP Get Query Result action

    Add the Body dynamic content from the HTTP Get Query Result action

    image.png
  • James Belich
    James Belich
    Kudos 1 First Anniversary Name Dropper Facilitator 1
    https://community.blackbaud.com/discussion/comment/310677#Comment_310677

    You're very welcome! Thank @Alex Wong and @Austen Brown as well - their posts yesterday helped me figure it out. 😀

  • Pippi Reader
    Pippi Reader
    Seventh Anniversary Kudos 1 Name Dropper Facilitator 1

    @Alex Wong @Dan Snyder I have the Prospect Status Updates for Moves Management - https://community.blackbaud.com/discussion/56628) also in use. I used to get emailed each day that the flow failed so I could resolve it but for some reason Power Automate has stopped doing that so I wasn't aware that it was failing until I received an email saying it had failed consecutively for 14 days and so they've turned the flow off. Hence why I'm only just picking up on it now.

    I know that in the past it has failed if the Constituent who is added to the list doesn't have a status selected but I've done a quick spot check and the IDs that are showing seem to have a Prospect Status selected so not sure if it is linked to that.

    It seems to be around the same time that this issue happened and just wondering if it might be linked and if so, if anyone knows what I need to do to my flow to fix it? I can't really find any info on what is making it fail - this is what I'm seeing when I go into the flow.

    Is anyone coming across similar issues and might be able to help?

    Thanks!

    image.png image.png
  • Dan Snyder
    Dan Snyder Community All-Star
    Tenth Anniversary Kudos 5 PowerUp Challenge - Chat for Blackbaud AI Task 3 bbcon 2025 Attendee Badge

    @Pippi Reader Can you share some of the steps before and after this apply to each? That will help to know what is being passed to the Get constituent prospect status action that is causing this flow to fail.

  • Pippi Reader
    Pippi Reader
    Seventh Anniversary Kudos 1 Name Dropper Facilitator 1

    Hey Dan - thanks for the help again 😀

    Sure no probs, here are the steps:

    image.png image.png image.png

    Does this help?

    Thanks

    Pippi

  • Pippi Reader
    Pippi Reader
    Seventh Anniversary Kudos 1 Name Dropper Facilitator 1

    Hey Dan - my mistake I have figured out the issue. It was one donor who hadn't got the status added, I thought I'd checked that but must have been having a moment of madness. So I redid the run and it succeeded!

    Do you by any chance know how I turn back on the failure emails I used to get - I only receive it after 14 days once it has failed for that long and it turns off but used to get this any time it failed.

    For my other flows it emails me that day so not sure what I've done wrong here?

    Thanks

    Pippi

Categories