Forum Discussion

mpros's avatar
mpros
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper 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
      Icon for Helper I rankHelper I
      1 year ago

      No luck trying it with sharepoint connection, same error:

      Ciao