OAuth error when creating a dataflow from a SharePoint folder

[Anonymous]

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-T....

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

Regards,

Brice

[Anonymous]

Hi lbendlin, thanks for your quick answer.

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

[lbendlin · Accepted solution]

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

[Anonymous]

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

[lbendlin]

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