PBI desktop dynamic sql oracle query working - but not working in service through Gateway

[mpros]

Goodmorning,
the flow is extracting queries from a sharepoint table and executing them as a function in powerquery to generate a custom column. For some reasons the same model working perfectly in desktop, it's throwing an error in Service:

Ultimo aggiornamento non riuscito: 21/11/2024, 11:33:53
Si è verificato un errore durante l'elaborazione dei dati nel set di dati.Nascondi dettagli

Errore dell'origine dati:	{"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":"Web: Request failed: Documents/Template_queryxlsx_xlsx/_api/contextinfo"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Web"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"Documents/Template_queryxlsx_xlsx/_api/contextinfo"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Source.
URI cluster:	WABI-WEST-US-C-PRIMARY-redirect.analysis.windows.net
ID attività:	bdc1bb62-3191-4ffc-b0ff-16e3561b9759
ID richiesta:	cad379be-c226-68e8-48fa-0aa01b73a7f9 Credentials and datasources are correctly set-up.

[collinq]

Hey @mpros ,

Based on the error message, it appears that the gateway is using the "Web" connection and that this is not the correct connection type.  The message states : "Web: Request failed:"   Is that supposed to be the Oracle part or perhaps you have a different data source as well in your query?

[mpros]

Hi @collinq and thank you for the reply. 
Suggested solution has been tried already. Have a duplicate of this post at the following URL as it was marked as spam: https://community.fabric.microsoft.com/t5/Service/Service-Gateway-Updates-Fails-while-working-in-Des...
Ciao