Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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",...}}} 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.

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.