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?