The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.