Forum Discussion

mpros's avatar
mpros
Helper I
1 year ago

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

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 des...
Need Help
lbendlin's avatar
lbendlin
Super User
1 year ago

For file sources on Sharepoint use "SharePoin Folder", not "Web".

 

Scheduled refresh may still fail due to formula firewall restrictions.

mpros's avatar
mpros
Helper I
1 year ago

Dear  lbendlin, 
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

  • mpros's avatar
    mpros
    Helper I
    1 year ago

    No luck trying it with sharepoint connection, same error:

    Ciao