Forum Discussion
oauth2 option not appearing for SharePoint list data
Have you corrected the URL in your Power Query code and re-published?
Super User
the data used is from a SharePoint List so is on the cloud
Not necessarily. Sharepoint can also be on-premise in which case you need Windows Auth, not OATH2.
Your sharepoint site url is missing the "https://". You have specified "http://".
Hi lbendlin, thanks for the reply
So if i click on Gateway connection it says "you don't need a gateway for this dataset, because all of its data sources are in the cloud" so i believe my sharepoint list is? Would you know if i need to go into my data source permissions and edit them? I've tried doing this and sign into my microsoft account and nothing seems to work. Do you know of any reasons why i wouldn't be able to scheduele a refresh or the steps i need to do to make sure I have set up everything correctly?
Thanks
- lbendlin
Have you corrected the URL in your Power Query code and re-published?