Forum Discussion
Solved
Getting Access is forbidden error when connecting OneDrive excel file
How do I get to the Authenticate screen to input credentials? Saw the screen once and cannot get back to it.
With the SharePoint Folder connector you only use the site URL and then navigate to the file with the FileName and FolderPath columns. Delete the url text after the site level.
Regards,
Pat
Yes. That happens sometimes with some sources. To get there in this case, go to the query editor and start a new blank query. In the Formula Bar (check the box in View tab if you don't see it) and write the first line of your query like = Web.Contents("<your url>")
You should then get the error but also a button you can click to Edit Crendentials for that source.
Regards,
Pat
Can I get a little more details?
Pasted code but did not get the box to enter credentials. Got the following: