Forum Discussion

slhangen's avatar
slhangen
Icon for Helper II rankHelper II
5 years ago
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.
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Go to File/Options and Settings/Data Source Settings (or choose Data Source Settings in the query editor).

Regards,

Pat

  • slhangen's avatar
    slhangen
    Icon for Helper II rankHelper II
    5 years ago

    My data is not in there.  I cannot load data, keep getting access forbidden error.  Need to authenticate data before it loads into model, right?

  • slhangen's avatar
    slhangen
    Icon for Helper II rankHelper II
    5 years ago

     

     

    When I paste link into web form I get this error.

     

    Need to get to this:

    But I can't figure out how to access this box