Power BI connector- Refresh error

Carol Grant

I tried to do a data refresh on a report that is posted to the service and received this error. It uses most of the fields from the Power BI Connector.

Earlier today, it said it had failed on Gift Custom Fields, now it looks like its saying there is an issue with the All Gifts. Anyone else have issues or how to resolve this? I am pulling over all gifts from the connector then filtering after.

Last refresh failed: 1/5/2023, 3:21:31 PM
There was an error when processing the data in the dataset.Hide details

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":"<ccon>Web.Contents failed to get contents from 'https://api.sky.blackbaud.com/gift/v1/gifts?limit=5000&offset=415000' (500): Internal Server Error</ccon>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Blackbaud"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"Blackbaud"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Url","detail":{"type":1,"value":"https://api.sky.blackbaud.com/gift/v1/gifts?limit=5000&offset=415000"}}],"exceptionCulprit":1}}} Table: All Gifts.
Cluster URI:	WABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net
Activity ID:	aed02654-c42d-4c7e-8da9-997539494565
Request ID:	becfb744-dc84-f990-9926-45b4d8e4a049
Time:	2023-01-05 20:21:31Z

Thanks,

Carolyn Grant

Middlebury College

Matt Thacker

Hey @Carolyn Grant, typically I see this error thrown when a table name has been changed in the model from the source data. I see you have a table called All Gifts, is that originally the Gift table?

Carol Grant

@Matt Thacker- Hi Matt- thanks for responding! The table name has been changed from it's original of Gifts. Yes, that is originally the Gift table.

It did refresh a few weeks ago using the same name All Gifts. Any suggestions? I have many measures that reference that table and fields.

Carol Grant

Hi @Matt Thacker or anyone- now I'm getting this error constantly. It runs for a bit and then stops.

{"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":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\\"kind\\":\\"Blackbaud\\",\\"path\\":\\"Blackbaud\\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: Gift custom fields.

Does the connector have a time out where you are logged out if we are SSO? Why would it stop and give me Invalid Connection Credentials?

Carol Grant

After some intense problem solving my connection was timing out and it was stopping at the Gift Custom Fields table. I did NOT have Skip Test Connection checked in the on premises gateway so it timed out. Lesson for others.