Data source error: {"error":{"code":"DM_GWPipeline_Gateway_InvalidMashupConnectionString","pbi.error

[JRA]

Hi All, 
I am currently trying to use the  Trino Custom Connector
and although the data refreshes fine form othe Personal Mode Data Gateway, when published to the Power BI Service i just get the following error: 

{"error":{"code":"DM_GWPipeline_Gateway_InvalidMashupConnectionString","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidMashupConnectionString","parameters":{},"details":[],"exceptionCulprit":1}}} Table:
Cluster URI:	WABI-US-GOV-VIRGINIA-redirect.analysis.usgovcloudapi.net

has anyone been able to fix / overcome this problem?

[GilbertQ]

Hi @JRA 

As far as I am away to use a custom data connector new to instal the gateway in the standard mode, you then need to put your custom connector on your gateway server and only then will you be able to connect and refresh your data via the customer connector.

Use custom data connectors with the on-premises data gateway - Power BI | Microsoft Learn

[JRA]

The connector is in the DataGateway as well, so that shouldnt be part of the issue. 

[GilbertQ]

Hi @JRA 

If you could try the standard mode and see if that works?

[JRA]

the personal data gateway seems to work without issues. it seems this problem happens on the Enterprise Data Gateway servers.