Forum Discussion
Jojo197
Helper I
Helper ISharepoint List API connection - published data source credentials - oath2 not an option
I am connecting to a Sharepoint List using the api to improve refresh speed, but am unable to set up OAuth2 authentication in the data source credentials after publishing and hence cannot set up a sc...
Hi Jojo197 - Could you please use Implemation="2.0" version of the Power Query SharePoint connector - Power Query SharePoint Online list connector - Power Query | Microsoft Learn? Have you considered separating the SharePoint List read from any transformation by using Dataflow to extract data and then another to transform it?
Jojo197Helper I
Helper IThanks for the response. I tried using the online list connector with just a source and navigation step but I am getting the same issue except only the anonymous option is showing up now.
What do you mean by using Dataflow to extract data and another to transform?