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

Brass Contributor

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.

 

 

 

davidmaddock54_0-1640126519210.png

 

0 Replies