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

Question

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:53Si è verificato un errore durante l'elaborazione dei dati nel set di dati.Nascondi dettagliErrore 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.netID attività:bdc1bb62-3191-4ffc-b0ff-16e3561b9759ID richiesta:cad379be-c226-68e8-48fa-0aa01b73a7f9Credentials and datasources are correctly set-up.&nbsp;

collinq · Answer

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

mpros · Answer

Hi&nbsp;collinq&nbsp;and thank you for the reply.&nbsp;Suggested solution has been tried already. Have a duplicate of this post at the following URL as it was marked as spam:&nbsp;https://community.fabric.microsoft.com/t5/Service/Service-Gateway-Updates-Fails-while-working-in-Desktop-Service/m-p/4296823#M257397Ciao

Forum Discussion

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

2 Replies

Related content

Power BI Service Refresh Failing for Dynamic SharePoint Web.Contents (Works in Desktop)

Dynamic Filter

Visuals working in desktop but not in service

Power BI Desktop not working after update

Custom Visual - Export to PDF not working in PBI Desktop

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.