Microsoft Power BI data refresh issue - recent last 3 days

Megan Densley
Megan Densley
Second Anniversary Name Dropper Participant Facilitator 1
in SKY Developer General Discussions

Has Blackbaud changed anything in the SKY API for authorization in the Power BI connector?

We have several dashboards that rely on the Power BI connector. All was working well until a few days ago when we are getting similar errors on all of our reports. I updated the gateway 3 weeks ago and all was working well until 4-24-25 when we received errors like the following:

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The remote name could not be resolved: 'api.sky.blackbaud.com'"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"19005"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"https://api.sky.blackbaud.com/fundraising/v1/funds?include_inactive=true&limit=5000"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Fund.
Cluster URI: WABI-WEST-US-C-PRIMARY-redirect.analysis.windows.net
Activity ID: d6d19b61-5c55-42c6-8617-ea767abced63
Request ID: bbe63751-1569-4bdb-a289-cd48be9c0f1c
Time: 2025-04-25 19:09:06Z

The issue seems to be that we cannot connect to api.sky.blackbaud.com - verified this in another browser window and on two different machines with different users.

5065eb8920ba8a6b246a2dff9ba0acae-huge-im

Comments

  • Erik Leaver
    Erik Leaver Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Megan Densley I successfully just used the “Try it” for the get fund api in the sky developer console. Have you tried that as a first troubleshooting step?

  • Rebecca Sundquist
    Rebecca Sundquist Blackbaud Employee
    Seventh Anniversary Kudos 2 Name Dropper Participant

    @Megan Densley, the Power BI custom connector from GitHub has been working consistently for me. Today I downloaded and set up the latest version of the Power BI custom connector from GitHub - blackbaud/powerbi-connector: Blackbaud data connectors for Power Query and Power BI , just to make sure all is still good.

    The reason Erik mentioned trying the fund api in the Sky Developer Console is because this is the way to authenticate and confirm that the APIs are working. Popping that URL into a browser will not initiate the authentication for you. Using the developer console requires having the Sky API Console application added to your environment from the Marketplace, which your organization has probably completed already.

    Authentication to the Power BI custom connector also relies on an application added to your environment. You will want to verify that your Power BI Connector's app is still authorized and has scope to read data.

    Are you an owner of the application that was created for the Power BI connector? Below is a screen shot of my app's Environments list. We've seen cases recently where Authorized = No. Other organizations have resolved this by removing the app from their environment and adding it again. Is this happening for you?

    c457bf3ea12baf4215105fb4c8fa3e23-huge-im


  • Megan Densley
    Megan Densley
    Second Anniversary Name Dropper Participant Facilitator 1

    @Rebecca Sundquist

    Thank you for messaging. Yes, I have been able to verify that I am the application owner and access is authorized.

    We didn't change anything, on 4-24 the powerBI refreshes started failing. The gateway is up-to-date so that isn't the issue. I am having issues with connecting to the connector on the university network but am able to at home.

    When I click on the endpoint reference in the sky developer console, I get the following error (2nd image).

    43163b2fb3fbc26e4c862b9c3835d10f-huge-im
    59efdfc5af55efa6292af81bfa4c1172-huge-im





  • Rebecca Sundquist
    Rebecca Sundquist Blackbaud Employee
    Seventh Anniversary Kudos 2 Name Dropper Participant

    @Megan Densley, sorry if my link to the Fund List end point was messed up. You should find the “Try It” button here: https://developer.sky.blackbaud.com/api#api=58bdd6c8d7dcde06046081d7&operation=ListFunds

    Hearing that you are able to connect at home and not on campus, makes me think it is a case where the custom connector's Blackbaud.mez file is not found in the expected file path. Are you using a different PC at home? The .mez file must be saved in the user's file path \\Documents\\Power BI Desktop\\Custom Connectors

    For me, this is nested in my rsundquist\\OneDrive\\Documents path. For a gateway, this will be under the gateway's registered user's path. By default, the gateway typically installs under the user NT SERVICE\\PBIEgwService. This is mentioned in the documentation GitHub - blackbaud/powerbi-connector: Blackbaud data connectors for Power Query and Power BI under Schedule Refresh Power BI Service > Step 2 - Set up the service account.

    It sounds like the way you are logging in while on campus is different from home. Therefore the .mez file is not located under the file path for your campus user. As for the gateway, since the refresh continued to work on Power BI Service after your initial update to the gateway, I didn't think this user and file path issue would be the root. There may yet be another issue in play.


Categories