Data Source Settings Power Query - can I add sources there?


I've been trying to get various sharepoint folders to play nice with PQ for months and have asked qu... 


I now have some queries working as intended through one sp site. I requested the set up of a new sp site for testing, in which I am an owner, and am back getting a forbidden access error when I try to link to it in PQ. 


I am unsure how the Data Source Settings window works. Once you've made a connection, it's easy to go in and check how it's all set up and adjust etc, but is there a space or way to pre-emptively ADD a data source here or in some other menu?


Basically, I want to get to the login/choose connection page pre-emptively and login to the sharepoint spaces I want to work with.






0 Replies