Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
6 years ago
Solved

Dataflow Accessing a Sharepoint Folder with an xlsx

I am creating a dataflow and I have a sharepoint folder with an xlsx in it (We made a Teams area)

 

I have copied the Sharepoint Link

 

https://testsite.sharepoint.com/sites/ExampleTeamsFoldername/Shared%20Documents/General

 

And I have attempted to use it in the data flow.

 

I have asked our admin about this and "it reads as though data sources in SharePoint Online locations don’t need to be added to the enterprise gateway…?" So we initially thought it didnt need a Gateway.

 

Attempting to go with this gets the following error

Sharepoint Request Failed. The remote Server returned an error (400) Bad request

 

So then I tried to use the Gateway

 

I dont think this is a data source on the Gateway. So before continuing, should this be a data source on the Gateway or and I doing this incorrectly?

 

Thanks in advance

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    You shouldn't need to use a gateway if you're using SharePoint online... If your company is using SharePoint server on-prem, then it will need to go through the gateway. 
    I have several dataflows connecting to sharepoint lists and folders, and have received the error a couple of times, I usually just need to edit the credentials and make sure that I'm signed in.

     

    Hope that helps!

    Kim