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.