Service Gateway Updates Fails while working in Desktop (Service settings are ok)

Question

Hello,I've created a custom function that retrieves dynamically queries values from a sharepoint excel file and execute in Oracle DB creating a custom column in power query, which works fine in desktop. The problem is that even if the gateway is setup correctly, the updating job goes in error:&nbsp;&nbsp;Errore

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: Accoda1.&nbsp;I've ben trying to map excel data source both on cloud and on premise-gateway obtaining same result.Any Ideas?Thanks

lbendlin · Answer

For file sources on Sharepoint use "SharePoin Folder", not "Web".
&nbsp;
Scheduled refresh may still fail due to formula firewall restrictions.

mpros · Answer

Dear&nbsp;&nbsp;lbendlin,&nbsp;I have many other flows working correctly with web connection. May it be the combination of the two?I'll give it a try with sharepoint folder, and update you.Ciao

poojara_d12 · Answer

Hi&nbsp;mpros&nbsp;Your custom function works in Power BI Desktop but fails in the Power BI Service due to a gateway issue when accessing the SharePoint Excel file.Key points:Error Cause: The gateway cannot access the SharePoint data source, returning a DataSource.Error.Root Problem: Likely related to authentication or incorrect configuration of the data source in the Power BI Service.Tried Solutions: Mapping the data source both to cloud and on-premises gateways gave the same error.Recommendations:Verify that the SharePoint data source credentials in Power BI Service are correctly configured.Ensure the gateway is set to support cloud sources like SharePoint.If using OAuth authentication, confirm it’s supported and configured properly in the gateway and Power BI Service.Further troubleshooting might involve testing direct access to the SharePoint file from the gateway machine.&nbsp;Did I answer your question? Mark my post as a solution, this will help others!If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂Kind Regards,PoojaraData Analyst | MSBI Developer | Power BI ConsultantPlease Subscribe my YouTube for Beginners/Advance Concepts:&nbsp;https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS&nbsp;

mpros · Answer

No luck trying it with sharepoint connection, same error:Ciao

mpros · Answer

Dear&nbsp;Poojara_D12&nbsp;,Credentials and OAuth2 configured correctly in gateway and cloud; I have so many models running on top of that that gets updated by service job consistently:It only occurs with combination of custom function that queries dynamically on Oracle DBCiao

Forum Discussion

Service Gateway Updates Fails while working in Desktop (Service settings are ok)

10 Replies

Related content

Gallery Terms of Service

Service Date

Service - RLS

Language settings in Power BI Service

Power bi service