Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Scheduled Refresh with Custom Connector fails when more than one query is included in the refresh

I have created a customer connector that accesses our web application using OAuth2. I have been able to successfully create a new data source using the connector and get authenticated.

 

The way the connector works is by hving a navigation table with child navigation tables that query "views" with are just API request with json response objects.

 

Everything works as expected in Power BI Desktop no matter how many queries I am importing, when I only have a single view/query chosen and publish the report the online report refresh is successful. However, if I add an additional query to be loaded, I get the following error.

 

{"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 cannot be used for the Assemble_Views source. (Source at https://develop-smoke.internalassemble.com/.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"Assemble_Views"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"https://develop-smoke.internalassemble.com/"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"CredentialInvalid"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"Assemble_Views\",\"path\":\"https://develop-smoke.internalassemble.com/\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"CredentialInvalid"}}],"exceptionCulprit":1}}} Table: All Assemble Quantity Properties.

 

Request ID:31653d81-770f-e5ae-1ada-923203544e7a

 

Activity ID:31653d81-770f-e5ae-1ada-923203544e7a

 

I have reached out to Microsoft support and created and issue on Github/DataConnectors, Microsoft support was unable to help and I never got a response to my Github issue. I have been trying to get this working for months now and any help would be greatly appreciated.

No Replies