Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

OAuth error when creating a dataflow from a SharePoint folder

Hi, I am trying to create a dataflow using the SharePoint folder connector.

 

The popup window opens and closes after 1s and I got an error during the authentication.

 

 

I tried the solution from this post and it didn't work : https://community.powerbi.com/t5/Power-Query/Creating-a-Dataflow-from-a-SharePoint-Online-list-get-There-was/td-p/782512.

 

The connection to the SharePoint folder is working on Power BI desktop.

 

Regards,

 

Brice

Dataflow
  • lbendlin's avatar
    lbendlin
    4 years ago

    You must use a gateway for on-prem SharePoint and likely need to switch to Windows authentication.

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Please confirm that this is SPO and not on-premise sharepoint.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi lbendlin, thanks for your quick answer.

     

    This is on-premise sharepoint. Is there still a way to create a connection ?

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      You must use a gateway for on-prem SharePoint and likely need to switch to Windows authentication.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thanks a lot! It's working well using a standard gateway and windows authentication mode.