Custom Power BI connector cannot refresh the dataset in PowerBI portal

Iris Tam

I am able to connect Raiser's Edge NXT data using the custom Power BI connector on my desktop. I published the report to the Power BI portal. We have a generic Blackbaud ID account with full access to all the modules. I add this account to the Contributor List in the Application as well. The stored credential shows OK. Our DBA used this account to set up the data refresh. But it fails to refresh. Is there anything else I'm missing.

Here is the error message from the portal:

{"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the Blackbaud source are invalid. (Source at Blackbaud.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"Blackbaud"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceOriginKind","detail":{"type":1,"value":"Blackbaud"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath","detail":{"type":1,"value":"Blackbaud"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"Blackbaud"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessForbidden"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\\"kind\\":\\"Blackbaud\\",\\"path\\":\\"Blackbaud\\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessForbidden"}}],"exceptionCulprit":1}}} Table: Fund.

Matt Thacker

Do you have an on-premise gateway setup to allow refresh from the Power BI service?

Iris Tam

We have Azure Data Gateway.

Matt Thacker

Not sure what an Azure Data Gateway is, but the connector is stored locally on your machine so the gateway needs to exist locally as well and connected to your PBI service. It should appear like this (we're RE NXT Azure hosted).

Iris Tam

I have a the connector is stored locally on my machine but I need to publish this report to the PBI server. If I use the on-premise gateway setup, does that mean my machine has to be “on” all the time in order to refresh the dataset on the server?

There is also a connector (Blackbaud.mez files) stored on the server. The dataset is able to display the data. But it fails when trying to schedule refresh.

Laurie Carr

Hi, I'm Laurie, the DBA working with Iris. We are running the Data Gateway on-prem. I have uploaded the .mez file, from Iris, to the server, in the Custom Connection folder. Then on PowerBI, I try to set up the connection, using the generic Blackbaud ID account, and I can't get it to work. But I do see the Blackbaud connection, which I am selecting. We are using a domain account, and I think that it is getting messed up, as I keep seeing that it is trying to use my account, not the generic account. I read an article about possibly setting our Data Gateway service to run on a domain account. I haven't been able to talk to someone about making this change yet, but what do you think? Or any other suggestions? Thanks.

Matt Thacker

I’d be happy to jump on a Teams and I can help you troubleshoot the issue.

Laurie Carr

That would be great, thanks! I am available the rest of today, or tomorrow from 7-9am PST or anytime after 12pm PST.

Matt Thacker

Laurie Carr:

That would be great, thanks! I am available the rest of today, or tomorrow from 7-9am PST or anytime after 12pm PST.

I’m going to send you a PM